//package com.irdstudio.efp.esb.api.rest.pboc;
//
//import static com.irdstudio.basic.sequence.service.DefaultPatternDescriptor.SEQ;
//
//import java.util.ArrayList;
//import java.util.List;
//import java.util.Objects;
//
//import javax.servlet.http.HttpServletRequest;
//
//import org.apache.commons.codec.language.bm.PhoneticEngine;
//import org.slf4j.Logger;
//import org.slf4j.LoggerFactory;
//import org.springframework.beans.factory.annotation.Autowired;
//import org.springframework.beans.factory.annotation.Qualifier;
//import org.springframework.validation.BindingResult;
//import org.springframework.validation.annotation.Validated;
//import org.springframework.web.bind.annotation.ModelAttribute;
//import org.springframework.web.bind.annotation.PostMapping;
//import org.springframework.web.bind.annotation.RequestMapping;
//import org.springframework.web.bind.annotation.RestController;
//
//import com.alibaba.fastjson.JSON;
//import com.alibaba.fastjson.JSONObject;
//import com.irdstudio.basic.framework.core.exception.BizException;
//import com.irdstudio.basic.framework.core.exception.ESBException;
//import com.irdstudio.basic.framework.core.util.TraceUtil;
//import com.irdstudio.basic.sequence.service.DefaultPatternDescriptor;
//import com.irdstudio.basic.sequence.service.PatternDescriptor;
//import com.irdstudio.basic.sequence.service.facade.PatternedLimitableSeqService;
//import com.irdstudio.cdp.pboc.service.facade.PbocAssetDetailService;
//import com.irdstudio.cdp.pboc.service.facade.PbocBadDebtsService;
//import com.irdstudio.cdp.pboc.service.facade.PbocBondsmanService;
//import com.irdstudio.cdp.pboc.service.facade.PbocCarService;
//import com.irdstudio.cdp.pboc.service.facade.PbocCivilJudgementService;
//import com.irdstudio.cdp.pboc.service.facade.PbocCreditBasicService;
//import com.irdstudio.cdp.pboc.service.facade.PbocCreditGuaranteelDetailService;
//import com.irdstudio.cdp.pboc.service.facade.PbocCreditPromptService;
//import com.irdstudio.cdp.pboc.service.facade.PbocCreditStatusService;
//import com.irdstudio.cdp.pboc.service.facade.PbocCreditqueryDetailService;
//import com.irdstudio.cdp.pboc.service.facade.PbocCreditquerySummaryService;
//import com.irdstudio.cdp.pboc.service.facade.PbocDeliverySumService;
//import com.irdstudio.cdp.pboc.service.facade.PbocDescriptionService;
//import com.irdstudio.cdp.pboc.service.facade.PbocEndowmentInsurancecacheService;
//import com.irdstudio.cdp.pboc.service.facade.PbocForcecarryService;
//import com.irdstudio.cdp.pboc.service.facade.PbocHouseprovidentService;
//import com.irdstudio.cdp.pboc.service.facade.PbocIdentityService;
//import com.irdstudio.cdp.pboc.service.facade.PbocJobService;
//import com.irdstudio.cdp.pboc.service.facade.PbocLoadBasicService;
//import com.irdstudio.cdp.pboc.service.facade.PbocLoadGuaranteelDetailService;
//import com.irdstudio.cdp.pboc.service.facade.PbocLoadOverdueService;
//import com.irdstudio.cdp.pboc.service.facade.PbocLoadStatusService;
//import com.irdstudio.cdp.pboc.service.facade.PbocLowIncomeService;
//import com.irdstudio.cdp.pboc.service.facade.PbocNearcreditStatusService;
//import com.irdstudio.cdp.pboc.service.facade.PbocNoneSettleService;
//import com.irdstudio.cdp.pboc.service.facade.PbocNoneworkoffCreditcardService;
//import com.irdstudio.cdp.pboc.service.facade.PbocNoneworkoffNearcreditcardService;
//import com.irdstudio.cdp.pboc.service.facade.PbocOwingTaxesService;
//import com.irdstudio.cdp.pboc.service.facade.PbocPracticReqService;
//import com.irdstudio.cdp.pboc.service.facade.PbocPunishService;
//import com.irdstudio.cdp.pboc.service.facade.PbocResidenceService;
//import com.irdstudio.cdp.pboc.service.facade.PbocRewardService;
//import com.irdstudio.cdp.pboc.service.facade.PbocSponsorialDetailService;
//import com.irdstudio.cdp.pboc.service.facade.PbocTelecomService;
//import com.irdstudio.cdp.pboc.service.facade.QueryReportService;
//import com.irdstudio.cdp.pboc.service.vo.PbocAssetDetailVO;
//import com.irdstudio.cdp.pboc.service.vo.PbocBadDebtsVO;
//import com.irdstudio.cdp.pboc.service.vo.PbocBondsmanVO;
//import com.irdstudio.cdp.pboc.service.vo.PbocCarVO;
//import com.irdstudio.cdp.pboc.service.vo.PbocCivilJudgementVO;
//import com.irdstudio.cdp.pboc.service.vo.PbocCreditBasicVO;
//import com.irdstudio.cdp.pboc.service.vo.PbocCreditGuaranteelDetailVO;
//import com.irdstudio.cdp.pboc.service.vo.PbocCreditPromptVO;
//import com.irdstudio.cdp.pboc.service.vo.PbocCreditStatusVO;
//import com.irdstudio.cdp.pboc.service.vo.PbocCreditqueryDetailVO;
//import com.irdstudio.cdp.pboc.service.vo.PbocCreditquerySummaryVO;
//import com.irdstudio.cdp.pboc.service.vo.PbocDeliverySumVO;
//import com.irdstudio.cdp.pboc.service.vo.PbocDescriptionVO;
//import com.irdstudio.cdp.pboc.service.vo.PbocEndowmentInsurancecacheVO;
//import com.irdstudio.cdp.pboc.service.vo.PbocForcecarryVO;
//import com.irdstudio.cdp.pboc.service.vo.PbocHouseprovidentVO;
//import com.irdstudio.cdp.pboc.service.vo.PbocIdentityVO;
//import com.irdstudio.cdp.pboc.service.vo.PbocJobVO;
//import com.irdstudio.cdp.pboc.service.vo.PbocLoadBasicVO;
//import com.irdstudio.cdp.pboc.service.vo.PbocLoadGuaranteelDetailVO;
//import com.irdstudio.cdp.pboc.service.vo.PbocLoadOverdueVO;
//import com.irdstudio.cdp.pboc.service.vo.PbocLoadStatusVO;
//import com.irdstudio.cdp.pboc.service.vo.PbocLowIncomeVO;
//import com.irdstudio.cdp.pboc.service.vo.PbocNearcreditStatusVO;
//import com.irdstudio.cdp.pboc.service.vo.PbocNoneSettleVO;
//import com.irdstudio.cdp.pboc.service.vo.PbocNoneworkoffCreditcardVO;
//import com.irdstudio.cdp.pboc.service.vo.PbocNoneworkoffNearcreditcardVO;
//import com.irdstudio.cdp.pboc.service.vo.PbocOwingTaxesVO;
//import com.irdstudio.cdp.pboc.service.vo.PbocPracticReqVO;
//import com.irdstudio.cdp.pboc.service.vo.PbocPunishVO;
//import com.irdstudio.cdp.pboc.service.vo.PbocResidenceVO;
//import com.irdstudio.cdp.pboc.service.vo.PbocRewardVO;
//import com.irdstudio.cdp.pboc.service.vo.PbocSponsorialDetailVO;
//import com.irdstudio.cdp.pboc.service.vo.PbocTelecomVO;
//import com.irdstudio.cdp.pboc.service.vo.QueryReportVO;
//import com.irdstudio.efp.esb.api.bean.nls.RespLoanAppBean;
//import com.irdstudio.efp.esb.api.bean.pboc.ReqPbocAppBean;
//import com.irdstudio.efp.esb.api.bean.pboc.RespPbocAppBean;
//import com.irdstudio.efp.esb.api.common.EsbRespServiceBeanCreator;
//
//import com.irdstudio.efp.esb.common.constant.EsbBizEnums;
//import com.irdstudio.efp.esb.common.constant.EsbSysHeadEnums;
//import com.irdstudio.efp.esb.common.server.req.EsbReqServiceBean;
//import com.irdstudio.efp.esb.common.server.resp.EsbRespServiceBean;
//
///**
// * TODO
// * 
// * @author weijj
// * @since 2019年3月7日 上午10:55:39
// * @version 1.0
// */
//@RestController
//@RequestMapping("/esb")
//public class PbocApplyController {
//	private static Logger logger = LoggerFactory.getLogger(PbocApplyController.class);
//	public static final PatternDescriptor PATTERN = DefaultPatternDescriptor.of("S" + SEQ, 9);
//
//	@ModelAttribute("esbReqServiceBean")
//	public EsbReqServiceBean getReqEsbHeadBean(HttpServletRequest request) {
//		logger.info("校验 ESB请求系统头和请求应用头对象!");
//		EsbReqServiceBean esbReqServiceBean = (EsbReqServiceBean) request.getAttribute("esbReqServiceBean");
//		return esbReqServiceBean;
//	}
//
//	@ModelAttribute("reqPbocAppBean")
//	public ReqPbocAppBean getReqEsbBodyBean(HttpServletRequest request) {
//		logger.info("校验 ESB请求体对象！");
//		String esbReqBody = (String) request.getAttribute("esbReqBody");
//		return JSONObject.parseObject(esbReqBody, ReqPbocAppBean.class);
//	}
//
//	@PostMapping("/")
//	public EsbRespServiceBean doRecv(
//			@Validated @ModelAttribute("esbReqServiceBean") EsbReqServiceBean esbReqServiceBean, BindingResult br1,
//			@Validated @ModelAttribute("reqPbocAppBean") ReqPbocAppBean reqPbocAppBean, BindingResult br2,
//			Exception exception) throws Exception {
//		String reportId = reqPbocAppBean.getZxsReportNo();
//		String glblSrlNo = esbReqServiceBean.getSysHead().getGlblSrlNo();
//		TraceUtil.setTraceId(glblSrlNo);
//		logger.info("征信系统开始----------：" + reportId + "------------全局流水号" + glblSrlNo);
//		try {
//			// 1.通过切面校验进件申请参数是否正确，如不正确则返回错误信息
//			if (Objects.nonNull(exception)) {
//				throw exception;
//			}
//			// 2.获取业务逻辑字段
//			// 2.1查询信息
//			String requestTime = reqPbocAppBean.getZxsQueryTime();
//			String reportTime = reqPbocAppBean.getZxReportDate();
//			String cername = reqPbocAppBean.getZxsBeQueryName();
//			String certype = reqPbocAppBean.getZxsBeQueryPrcType();
//			String cercode = reqPbocAppBean.getZxsBeQueryPrcid();
//			String user = reqPbocAppBean.getZxsQueryOperator();
//			String queryReason = reqPbocAppBean.getZxsQueryReason();
//			// 2.2身份信息
//			String identityPId = sequenceService.getSequence();
//			String identityFId = reportId;
//			String identitysex = reqPbocAppBean.getZxSex();
//			String identityBirth = reqPbocAppBean.getZxsBirthday();
//			String identityMarriage = reqPbocAppBean.getZxMaritalStatus();
//			String identityTelephone = reqPbocAppBean.getZxPhone();
//			String identityTeleCompany = reqPbocAppBean.getZxCompanyPhone();
//			String identityTeleHome = reqPbocAppBean.getZxHomePhone();
//			String identityEducation = reqPbocAppBean.getZxEducation();
//			String identityDegree = reqPbocAppBean.getZxDegree();
//			String identityCommunicationAddr = reqPbocAppBean.getZxMailingAddress();
//			String identityHouseholdAddr = reqPbocAppBean.getZxPermanentAddress();
//			// 2.3居住信息（列表）
//			String residencePId = sequenceService.getSequence();
//			String residenceFId = reportId;
//			String residenceSn = reqPbocAppBean.getZxsResidenceInfoNo();
//			String residenceAddress = reqPbocAppBean.getZxsDomicile();
//			String residenceAddrStatus = reqPbocAppBean.getZxsResidenceStatus();
//			String residenceUpdateDate = reqPbocAppBean.getZxsResidenceInfoUpdateDate();
//			// 2.4职业信息（列表）
//			String jobPId = sequenceService.getSequence();
//			String jobFId = reportId;
//			String jobSn = reqPbocAppBean.getZxsCareerInfoNo();
//			String jobCompany = reqPbocAppBean.getZxsCompanyName();
//			String jobAddress = reqPbocAppBean.getZxsCompanyAddress();
//			String jobProfession = reqPbocAppBean.getZxsCareer();
//			String jobTrade = reqPbocAppBean.getZxsCompanyIndustry();
//			String jobPost = reqPbocAppBean.getZxsPosition();
//			String jobPostTitle = reqPbocAppBean.getZxsJobTitle();
//			String jobInComYear = reqPbocAppBean.getZxsCompanyStartYear();
//			String jobUpdateDate = reqPbocAppBean.getZxsCareerInfoUpdate();
//			// 2.5信用提示
//			String creditPromptPId = sequenceService.getSequence();
//			String creditPromptFId = reportId;
//			String creditPromptHouseLoadNum = reqPbocAppBean.getZxHouseLoanCnt();
//			String creditPromptBusHouseloadNum = reqPbocAppBean.getZxCommerHouseLoanCnt();
//			String creditPromptOtherLoadNum = reqPbocAppBean.getZxLoanCnt();
//			String creditPromptFirstLoadMonth = reqPbocAppBean.getZxFirstLoanMonth();
//			String creditPromptCreditAccounts = reqPbocAppBean.getZxCreditCardAccountCnt();
//			String creditPromptFirstCreditMonth = reqPbocAppBean.getZxFirstCreditCardMonth();
//			String creditPromptNearcreditcardAccounts = reqPbocAppBean.getZxSemiCreditCardAccountCnt();
//			String creditPromptFirstNearcreditMonth = reqPbocAppBean.getZxFirstSemiCreditCardMonth();
//			String creditPromptDescriptionNum = reqPbocAppBean.getZxsDeclareCnt();
//			String creditPromptDissentNum = reqPbocAppBean.getZxsObjectionCnt();
//			// 2.6呆账信息汇总
//			String badDebtsPId = sequenceService.getSequence();
//			String badDebtsFId = reportId;
//			String badDebtsBadDebtsNum = reqPbocAppBean.getZxBadBebtsCnt();
//			int badDebtsBadDebtsRemain = reqPbocAppBean.getZxBadBebtsBalance();
//			String badDebtsAssetsNum = reqPbocAppBean.getZxRestDisposalCnt();
//			int badDebtsAssetsRemain = reqPbocAppBean.getZxRestDisposalBalaceAmt();
//			String badDebtsSponsorialNum = reqPbocAppBean.getZxGuaranteeCnt();
//			int badDebtsSponsorialRemain = reqPbocAppBean.getZxGuaranteeBal();
//			// 2.7逾期（透支）信息汇总
//			String deliverySumPId = sequenceService.getSequence();
//			String deliverySumFId = reportId;
//			String deliverySumLoadOverdueNum = reqPbocAppBean.getZxDelqCnt();
//			String deliverySumLoadOverdueMonths = reqPbocAppBean.getZxDelqMonths();
//			int deliverySumLoadOverdueMaxSum = reqPbocAppBean.getZx1MthDelqMaxAmt();
//			String deliverySumLoadOverdueMaxMonth = reqPbocAppBean.getZxMaxMonths();
//			String deliverySumCreditOverdueAccounts = reqPbocAppBean.getZxCreCardDelqAccoutCnt();
//			int deliverySumCreditOverdueMonths = reqPbocAppBean.getZxCreditCardAccuDelqCnt1();
//			int deliverySumCreditOverdueMaxSum = reqPbocAppBean.getZxCreCardDelqMaxAmt();
//			String deliverySumCreditOverdueMaxMonth = reqPbocAppBean.getZxCreCardMaxMonthsCnt();
//			String deliverySumNearcredit60dAccounts = reqPbocAppBean.getZxsSemiCrdCardOverdraftCnt60Days();
//			String deliverySumNearcredit60dMonths = reqPbocAppBean.getZxsSemiCrdCardAccuDelqCnt60Days();
//			String deliverySumNearcredit60dMaxSum = reqPbocAppBean.getZxsSemiCrdCardSumMthMaxBal60Days();
//			String deliverySumNearcredit60dMaxMonth = reqPbocAppBean.getZxsSemiCrdCardMthLenMax60Days();
//			// 2.8未结清贷款信息汇总
//			String noneSettlePId = sequenceService.getSequence();
//			String noneSettleFId = reportId;
//			String noneSettleLoadCorporationNum = reqPbocAppBean.getZxsUnclearedLoanLegalbodyNum();
//			String noneSettleLoadOrganizationNum = reqPbocAppBean.getZxLoanCompanyBalCnt();
//			String noneSettleNum = reqPbocAppBean.getZxLoanBalCnt();
//			int noneSettleContractSum = reqPbocAppBean.getZxLoanBalTotalAmt();
//			int noneSettleRemain = reqPbocAppBean.getZxLoanBalanceAmt();
//			int noneSettleLast6mRepay = reqPbocAppBean.getZxRcy6MAvgPayAmt();
//			// 2.9未销户贷记卡信息汇总
//			String noneworkoffCreditcardPId = sequenceService.getSequence();
//			String noneworkoffCreditcardFId = reportId;
//			String noneworkoffCreditcardIssuingCorporationNum = reqPbocAppBean.getZxIssuBankCorporateCnt();
//			String noneworkoffCreditcardIssuingOrganizationNum = reqPbocAppBean.getZxIssuBankCnt();
//			int noneworkoffCreditcardAccounts = reqPbocAppBean.getZxAccountCnt();
//			int noneworkoffCreditcardExtensionSum = reqPbocAppBean.getZxTotalCreditAmt();
//			int noneworkoffCreditcardSingleMaxExtension = reqPbocAppBean.getZxMaxCreditAmt();
//			int noneworkoffCreditcardSingleMinExtension = reqPbocAppBean.getZxMinCreditAmt();
//			int noneworkoffCreditcardUsedExtension = reqPbocAppBean.getZxUseCreditAmt();
//			int noneworkoffCreditcardLast6mAvgUsedextension = reqPbocAppBean.getZxRcy6MAvgUseCreditAmt();
//			// 2.10未销户准贷记卡信息汇总
//			String noneworkoffNearcreditcardPId = sequenceService.getSequence();
//			String noneworkoffNearcreditcardFId = reportId;
//			String noneworkoffNearcreditcardIssuingCorporationNum = reqPbocAppBean.getZxsUnclsCrdLegalbodyCnt();
//			String noneworkoffNearcreditcardIssuingOrganizationNum = reqPbocAppBean.getZxsUnclsCrdIssuBankNum();
//			String noneworkoffNearcreditcardAccounts = reqPbocAppBean.getZxsUnclsCrdAccountCnt();
//			String noneworkoffNearcreditcardExtensionSum = reqPbocAppBean.getZxsUnclsCrdCreditTotalAmt();
//			String noneworkoffNearcreditcardSingleMaxExtension = reqPbocAppBean.getZxsUnclsCrdSigBankMaxLmt();
//			String noneworkoffNearcreditcardSingleMinExtension = reqPbocAppBean.getZxsUnclsCrdSigBankMinLmt();
//			String noneworkoffNearcreditcardUsedExtension = reqPbocAppBean.getZxsUnclsCrdOverdraftBla();
//			String noneworkoffNearcreditcardLast6mAvgUsedextension = reqPbocAppBean
//					.getZxsUnclsCrdRec6mAveOverdraftBla();
//			// 2.11对外担保信息汇总
//			String bondsmanPId = sequenceService.getSequence();
//			String bondsmanFId = reportId;
//			String bondsmanSecuredNum = reqPbocAppBean.getZxWarrantLoanCnt();
//			int bondsmanSeceredMoney = reqPbocAppBean.getZxWarrantLoanAmt();
//			int bondsmanSeceredCapital = reqPbocAppBean.getZxWarrantLoanRate1();
//			// 2.12资产处置信息（列表）
//			String assetDetailPId = sequenceService.getSequence();
//			String assetDetailFId = reportId;
//			String assetDetailSn = reqPbocAppBean.getZxsAssetDisposalNo();
//			String assetDetailAssetManageCompany = reqPbocAppBean.getZxsAssetDisposalCompany();
//			String assetDetailRecipientDate = reqPbocAppBean.getZxsAssetDisposaDebtRecDate();
//			String assetDetailRecipientAmount = reqPbocAppBean.getZxsAssetDisposaCredRightsAmt();
//			String assetDetailLastRepayDate = reqPbocAppBean.getZxsAssetDisposaLstRepayDate();
//			String assetDetailRemain = reqPbocAppBean.getZxsAssetDisposaBalance();
//			// 2.13保证人代偿信息
//			String sponsorialDetailPId = sequenceService.getSequence();
//			String sponsorialDetailFId = reportId;
//			String sponsorialDetailSn = reqPbocAppBean.getZxsGuartCompsNo();
//			String sponsorialDetailSponsorialOrganization = reqPbocAppBean.getZxsGuartCompsOrg();
//			String sponsorialDetailReplaceRepayDate = reqPbocAppBean.getZxsGuartCompsLstCompsDate();
//			String sponsorialDetailReplaceRepaySum = reqPbocAppBean.getZxsGuartCompsTotalAmt();
//			String sponsorialDetailLastRepayDate = reqPbocAppBean.getZxsGuartCompsLstRepayDate();
//			String sponsorialDetailRemain = reqPbocAppBean.getZxsGuartCompsBalance();
//			// 2.14贷款基本信息
//			String loadBasicPId = sequenceService.getSequence();
//			String loadBasicFId = reportId;
//			String loadBasicBegDate = reqPbocAppBean.getZxsLoanDate();
//			String loadBasicOrganizationType = reqPbocAppBean.getZxsLoanOrgType();
//			String loadBasicOrganizationName = reqPbocAppBean.getZxsLoanOrgName();
//			String loadBasicLoadAmount = reqPbocAppBean.getZxsLoanAmt();
//			String loadBasicCurrency = reqPbocAppBean.getZxsLoanCurrency();
//			String loadBasicLoadType = reqPbocAppBean.getZxsLoanUse();
//			String loadBasicBusinessSn = reqPbocAppBean.getZxsLoanBusinessNo();
//			String loadBasicBondsType = reqPbocAppBean.getZxsLoanPledge();
//			String loadBasicLoadPeriods = reqPbocAppBean.getZxsLoanPeriodsTotalNum();
//			String loadBasicRepayWay = reqPbocAppBean.getZxsLoanRepayMode();
//			String loadBasicEndDate = reqPbocAppBean.getZxsLoanDueDate();
//			String loadBasicUpdateDate = reqPbocAppBean.getZxsLoanDeadline();
//			String loadBasicLoadStatus = reqPbocAppBean.getZxsLoanAcctStatus();
//			String loadBasicRemain = reqPbocAppBean.getZxsAllLoanAcctBalanceList();
//			String loadBasicBegYearMonth = "";
//			String loadBasicEndYearMonth = "";
//			String loadBasicMonth24status = reqPbocAppBean.getZxsLoanRepayRecord24m();
//			String loadBasicSn = reqPbocAppBean.getZxsLoanNo();
//			// 2.15贷款状态信息
//			String loadStatusPId = sequenceService.getSequence();
//			String loadStatusFId = loadBasicSn;
//			String loadStatusLoadStatus = loadBasicLoadStatus;
//			String loadStatusFiveStyle = reqPbocAppBean.getZxsAllLoanAcctNowFiveclassList();
//			String loadStatusBasicLoadAmount = reqPbocAppBean.getZxsAllLoanAcctBalanceList();
//			String loadStatusRemainLoadPeriods = reqPbocAppBean.getZxsAllLoanAcctRemainPaySumList();
//			String loadStatusRepayAtMonth = reqPbocAppBean.getZxsLoanThisMonthRepayAmt();
//			String loadStatusNeedRepayDate = reqPbocAppBean.getZxsLoanRepayDate();
//			String loadStatusRepayedAtMonth = reqPbocAppBean.getZxsLoanThisMonthActualRepayAmt();
//			String loadStatusLastRepayDate = reqPbocAppBean.getZxsAccountRepaymentDate();
//			// 2.16贷款当前逾期信息
//			String loadOverduePId = sequenceService.getSequence();
//			String loadOverdueFId = loadBasicSn;
//			String loadOverdueOverduePeriods = reqPbocAppBean.getZxsAllLoanAcctNowDelqPeriodList();
//			String loadOverdueOverdueAmount = reqPbocAppBean.getZxsAllLoanAcctNowDelqAmtList();
//			String loadOverdueOverdue3160Amount = reqPbocAppBean.getZxsAllLoanAcctDelqAmt30To60DaysList();
//			String loadOverdueOverdue6190Amount = reqPbocAppBean.getZxsAllLoanAcctDelqAmt61To90DaysList();
//			String loadOverdueOverdue91180Amount = reqPbocAppBean.getZxsAllLoanAcctDelqAmt91To180DaysList();
//			String loadOverdueOverdue180Amount = reqPbocAppBean.getZxsAllLoanAcctDelqAmt180DaysList();
//			// 2.17贷记卡基本信息
//			String creditBasicPId = sequenceService.getSequence();
//			String creditBasicFId = reportId;
//			String creditBasicBegDate = reqPbocAppBean.getZxsCreCardDate();
//			String creditBasicOrganizationType = reqPbocAppBean.getZxsCreCardOrgType();
//			String creditBasicOrganizationName = reqPbocAppBean.getZxsCreCardOrgName();
//			String creditBasicCurrency = reqPbocAppBean.getZxsCreCardCurrency();
//			String creditBasicBusinessSn = reqPbocAppBean.getZxsCreCardBusinessNo();
//			String creditBasicExtension = reqPbocAppBean.getZxsCreCardLmt();
//			String creditBasicExtensionShare = reqPbocAppBean.getZxsCreCardShareLmt();
//			String creditBasicBondsType = reqPbocAppBean.getZxsCreCardPledge();
//			String creditBasicUpdateDate = reqPbocAppBean.getZxsCreCardDeadline();
//			String creditBasicCreditStatus = reqPbocAppBean.getZxsCreCardAcctStatus();
//			String creditBasicRemain = reqPbocAppBean.getZxsCreCardUsedLmt();
//			String creditBasicCreditType = "CRDT";
//			String creditBasicBegYearMonth = "";
//			String creditBasicEndYearMonth = "";
//			String creditBasicMonth24status = reqPbocAppBean.getZxsCreCardRepayRecord24m();
//			String creditBasicSn = reqPbocAppBean.getZxsCreCardNo();
//			// 2.18贷记卡状态信息
//			String creditStatusPId = sequenceService.getSequence();
//			String creditStatusFId = creditBasicSn;
//			String creditStatusCreditStatus = creditBasicCreditStatus;
//			String creditStatusUsedAmount = creditBasicRemain;
//			String creditStatusLast6monthAvg = reqPbocAppBean.getZxsCreCardRcy6MAvgUseCreditAmt();
//			String creditStatusMaxUsedAmount = reqPbocAppBean.getZxsCrecardMaxUsedAmt();
//			String creditStatusRepayAtMonth = reqPbocAppBean.getZxsCreCardNowShouldPayAmt();
//			String creditStatusBillDate = reqPbocAppBean.getZxsCreCardBillDate();
//			String creditStatusRepayedAtMonth = reqPbocAppBean.getZxsCreCardNowActualPayAmt();
//			String creditStatusLastRepayDate = reqPbocAppBean.getZxsCreditRepaymentDate();
//			String creditStatusOverduePeriods = reqPbocAppBean.getZxsAllCreCardNowDelqPeriodList();
//			String creditStatusOverdueAmount = reqPbocAppBean.getZxsCurrCreCardOverdueAmt();
//			// 2.19准贷记卡基本信息
//			String nearCreditBasicPId = sequenceService.getSequence();
//			String nearCreditBasicFId = reportId;
//			String nearCreditBasicBegDate = reqPbocAppBean.getZxsSemiCreCardDate();
//			String nearCreditBasicOrganizationType = reqPbocAppBean.getZxsSemiCreCardOrgType();
//			String nearCreditBasicOrganizationName = reqPbocAppBean.getZxsSemiCreCardOrgName();
//			String nearCreditBasicCurrency = reqPbocAppBean.getZxsSemiCreCardCurrency();
//			String nearCreditBasicBusinessSn = reqPbocAppBean.getZxsSemiCreCardBusinessNo();
//			String nearCreditBasicExtension = reqPbocAppBean.getZxsSemiCreCardLmt();
//			String nearCreditBasicExtensionShare = reqPbocAppBean.getZxsSemiCreCardShareLmt();
//			String nearCreditBasicBondsType = reqPbocAppBean.getZxsSemiCreCardPledge();
//			String nearCreditBasicUpdateDate = reqPbocAppBean.getZxsSemiCreCardDeadline();
//			String nearCreditBasicCreditStatus = reqPbocAppBean.getZxsSemiCreCardAcctStatus();
//			String nearCreditBasicRemain = reqPbocAppBean.getZxsSemiCreCardUsedLmt();
//			String nearCreditBasicCreditType = "NECT";
//			String nearCreditBasicBegYearMonth = "";
//			String nearCreditBasicEndYearMonth = "";
//			String nearCreditBasicMonth24status = reqPbocAppBean.getZxsSemiCreCardRepayRecord24m();
//			String nearCreditBasicSn = reqPbocAppBean.getZxsSemiCreCardNo();
//			// 2.20准贷记卡状态信息
//			String nearCreditStatusPId = sequenceService.getSequence();
//			String nearCreditStatusFId = nearCreditBasicSn;
//			String nearCreditStatusNearcreditStatus = nearCreditBasicCreditStatus;
//			String nearCreditStatusUsedAmount = nearCreditBasicRemain;
//			String nearCreditStatusLast6monthAvg = reqPbocAppBean.getZxsSemiCreCardRcy6MAvgUseCreditAmt();
//			String nearCreditStatusMaxUsedAmount = reqPbocAppBean.getZxsSemiCreCardMaxUsedAmt();
//			String nearCreditStatusBillDate = reqPbocAppBean.getZxsSemiCreCardBillDate();
//			String nearCreditStatusRepayedAtMonth = reqPbocAppBean.getZxsSemiCreCardNowActualPayAmt();
//			String nearCreditStatusLastRepayDate = reqPbocAppBean.getZxsSemiCreCardRepaymentDate();
//			String nearCreditStatusOverdue180dAmount = reqPbocAppBean.getZxsSemiCreCard180UnpaidBalance();
//			// 2.21对外贷款担保信息（列表）
//			String loadGuaranteelDetailPId = sequenceService.getSequence();
//			String loadGuaranteelDetailFId = reportId;
//			String loadGuaranteelDetailSn = reqPbocAppBean.getZxsLoanGuaranteeNo();
//			String loadGuaranteelDetailOrganization = reqPbocAppBean.getZxsLoanGuaranteeIssuOrg();
//			String loadGuaranteelDetailContractAmount = reqPbocAppBean.getZxsLoanGuaranteeContAmt();
//			String loadGuaranteelDetailIssueDate = reqPbocAppBean.getZxsLoanGuaranteeIssuDate();
//			String loadGuaranteelDetailEndDate = reqPbocAppBean.getZxsLoanGuaranteeExpDate();
//			String loadGuaranteelDetailBondsAmount = reqPbocAppBean.getZxsLoanGuaranteeAmt();
//			String loadGuaranteelDetailBasicAmount = reqPbocAppBean.getZxsLoanGuaranteeAcctBalance();
//			String loadGuaranteelDetailFiveStyle = reqPbocAppBean.getZxsLoanGuaranteeFiveclass();
//			String loadGuaranteelDetailNeedRepayDate = reqPbocAppBean.getZxsLoanGuaranteeRepayDate();
//			// 2.22对外信用卡担保信息（列表）
//			String creditGuaranteelDetailPId = sequenceService.getSequence();
//			String creditGuaranteelDetailFId = reportId;
//			String creditGuaranteelDetailSn = reqPbocAppBean.getZxsCreCardGuaranteeNo();
//			String creditGuaranteelDetailOrganization = reqPbocAppBean.getZxsCreCardGuaranteeIssuOrg();
//			String creditGuaranteelDetailContractAmount = reqPbocAppBean.getZxsCreCardGuaranteeLmt();
//			String creditGuaranteelDetailIssueDate = reqPbocAppBean.getZxsCreCardGuaranteeIssuDate();
//			String creditGuaranteelDetailBondsAmount = reqPbocAppBean.getZxsCreCardGuaranteeAmt();
//			String creditGuaranteelDetailUsedAmount = reqPbocAppBean.getZxsCreCardGuaranteeUseLmt();
//			String creditGuaranteelDetailBillDate = reqPbocAppBean.getZxsCreCardGuaranteeBillDate();
//			// 2.23欠税记录信息（列表）
//			String owingTaxesPId = sequenceService.getSequence();
//			String owingTaxesFId = reportId;
//			String owingTaxesSn = reqPbocAppBean.getZxsTaxArrearsNo();
//			String owingTaxesOrganization = reqPbocAppBean.getZxsTaxArrearsOrg();
//			String owingTaxesOwingTaxesSum = reqPbocAppBean.getZxsTaxArrearsTotalAmt();
//			String owingTaxesStatisticsDate = reqPbocAppBean.getZxsTaxArrearsStatDate();
//			// 2.24法院民事判决记录（列表）
//			String civilJudgementPId = sequenceService.getSequence();
//			String civilJudgementFId = reportId;
//			String civilJudgementSn = reqPbocAppBean.getZxsCivilJudgNo();
//			String civilJudgementCourt = reqPbocAppBean.getZxsCivilJudgCaseCourt();
//			String civilJudgementReason = reqPbocAppBean.getZxsCivilJudgCase();
//			String civilJudgementRegesterDate = reqPbocAppBean.getZxsCivilJudgStartDate();
//			String civilJudgementEndWay = reqPbocAppBean.getZxsCivilJudgCloseMode();
//			String civilJudgementResult = reqPbocAppBean.getZxsCivilJudgVerdictResult();
//			String civilJudgementResultBegDate = reqPbocAppBean.getZxsCivilJudgVerdictEffecDate();
//			String civilJudgementCaseObject = reqPbocAppBean.getZxsCivilJudgLitigationStandard();
//			String civilJudgementCaseObjectAmount = reqPbocAppBean.getZxsCivilJudgLitigationStandardAmt();
//			// 2.25强制执行记录（列表）
//			String forcecarryPId = sequenceService.getSequence();
//			String forcecarryFId = reportId;
//			String forcecarrySn = reqPbocAppBean.getZxsExecutesNo();
//			String forcecarryCourt = reqPbocAppBean.getZxsExecutesCourt();
//			String forcecarryReason = reqPbocAppBean.getZxsExecutesCase();
//			String forcecarryRegesterDate = reqPbocAppBean.getZxsExecutesStartDate();
//			String forcecarryEndWay = reqPbocAppBean.getZxsExecutesCloseMode();
//			String forcecarryCaseStatus = reqPbocAppBean.getZxsExecutesCaseStatus();
//			String forcecarryEndDate = reqPbocAppBean.getZxsExecutesCloseDate();
//			String forcecarryCaseObject = reqPbocAppBean.getZxsExecutesApplyStandard();
//			String forcecarryCaseObjectAmount = reqPbocAppBean.getZxsExecutesStandardValue();
//			String forcecarryHadObject = reqPbocAppBean.getZxsExecutesCompleteStandard();
//			String forcecarryHadObjectAmount = reqPbocAppBean.getZxsExecutesCompleteStandardAmt();
//			// 2.26行政处罚记录（列表）
//			String punishPId = sequenceService.getSequence();
//			String punishFId = reportId;
//			String punishSn = reqPbocAppBean.getZxsAdminiPenaltyNo();
//			String punishOrganization = reqPbocAppBean.getZxsAdminiPenaltyOrg();
//			String punishPunishContent = reqPbocAppBean.getZxsAdminiPenaltyContent();
//			String punishPunishAmount = reqPbocAppBean.getZxsAdminiPenaltyAmt();
//			String punishEffectiveDate = reqPbocAppBean.getZxsAdminiPenaltyEffecDate();
//			String punishEndDate = reqPbocAppBean.getZxsAdminiPenaltyDeadline();
//			String punishReconsiderResult = reqPbocAppBean.getZxsAdminiPenaltyReconResults();
//			// 2.27住房公积金参缴记录（列表）
//			String houseprovidentPId = sequenceService.getSequence();
//			String houseprovidentFId = reportId;
//			String houseprovidentSn = reqPbocAppBean.getZxsHouseFundNo();
//			String houseprovidentLocation = reqPbocAppBean.getZxsHouseFundPayLand();
//			String houseprovidentPayDate = reqPbocAppBean.getZxsHouseFundPayDate();
//			String houseprovidentFirstPayMonth = reqPbocAppBean.getZxsHouseFundPayFirstMonth();
//			String houseprovidentEndPayDate = reqPbocAppBean.getZxsHouseFundPayLastMonth();
//			String houseprovidentPayStatus = reqPbocAppBean.getZxsHouseFundPayStatus();
//			String houseprovidentPayPerMonth = reqPbocAppBean.getZxsHouseFundMonthPayAmt();
//			String houseprovidentSingleRate = reqPbocAppBean.getZxsHouseFundSelfRate();
//			String houseprovidentCompanyRate = reqPbocAppBean.getZxsHouseFundCompanyRate();
//			String houseprovidentCompany = reqPbocAppBean.getZxsHouseFundPayCompany();
//			String houseprovidentNewsUpdateDate = reqPbocAppBean.getZxsHouseFundRecordUpdate();
//			// 2.28养老保险金发放记录
//			String endowmentInsurancegrantPId = sequenceService.getSequence();
//			String endowmentInsurancegrantFId = reportId;
//			String endowmentInsurancegrantSn = reqPbocAppBean.getZxsEndowBasicNo();
//			String endowmentInsurancegrantLocation = reqPbocAppBean.getZxsEndowBasicPayLand();
//			String endowmentInsurancegrantPayDate = reqPbocAppBean.getZxsEndowBasicPayDate();
//			String endowmentInsurancegrantPayMonthSum = reqPbocAppBean.getZxsEndowBasicPayMonths();
//			String endowmentInsurancegrantBegWorkMonth = reqPbocAppBean.getZxsEndowBasicMonthOfWork();
//			String endowmentInsurancegrantPayStatus = reqPbocAppBean.getZxsEndowBasicPayStatus();
//			String endowmentInsurancegrantSingleBasicAmount = reqPbocAppBean.getZxsEndowBasicMoney();
//			String endowmentInsurancegrantPayAmount = reqPbocAppBean.getZxsEndowBasicThisMonthPayAmt();
//			String endowmentInsurancegrantNewsUpdateDate = reqPbocAppBean.getZxsEndowBasicRecordUpdate();
//			String endowmentInsurancegrantCompany = reqPbocAppBean.getZxsEndowBasicPayOrg();
//			String endowmentInsurancegrantTerminedReason = reqPbocAppBean.getZxsEndowBasicInterruptReason();
//			// 2.29低保救助记录（列表）
//			String lowIncomePId = sequenceService.getSequence();
//			String lowIncomeFId = reportId;
//			String lowIncomeSn = reqPbocAppBean.getZxsLowInsureNo();
//			String lowIncomePersonStyle = reqPbocAppBean.getZxsLowInsurePersonType();
//			String lowIncomeLocation = reqPbocAppBean.getZxsLowInsureLocation();
//			String lowIncomeCompany = reqPbocAppBean.getZxsLowInsureCompany();
//			String lowIncomeFamilyMonthIncome = reqPbocAppBean.getZxsLowInsureFamilyMonthIncome();
//			String lowIncomeApplyDate = reqPbocAppBean.getZxsLowInsureApplyDate();
//			String lowIncomeApproveDate = reqPbocAppBean.getZxsLowInsureApprovDate();
//			String lowIncomeNewsUpdateDate = reqPbocAppBean.getZxsLowInsureRecordUpdate();
//			// 2.30执业资格记录（列表）
//			String practicReqPId = sequenceService.getSequence();
//			String practicReqFId = reportId;
//			String practicReqSn = reqPbocAppBean.getZxsPracticeNo();
//			String practicReqReqName = reqPbocAppBean.getZxsPracticeName();
//			String practicReqReqLevel = reqPbocAppBean.getZxsPracticeGrade();
//			String practicReqGetReqDate = reqPbocAppBean.getZxsPracticeGetDate();
//			String practicReqEndReqDate = reqPbocAppBean.getZxsPracticeExpDate();
//			String practicReqDropReqDate = reqPbocAppBean.getZxsPracticeRevoceDate();
//			String practicReqOrganization = reqPbocAppBean.getZxsPracticeAwardOrg();
//			String practicReqLocation = reqPbocAppBean.getZxsPracticeOrgLocation();
//			// 2.31行政奖励记录（列表）
//			String rewardPId = sequenceService.getSequence();
//			String rewardFId = reportId;
//			String rewardSn = reqPbocAppBean.getZxsRewardNo();
//			String rewardOrganization = reqPbocAppBean.getZxsRewardOrg();
//			String rewardContent = reqPbocAppBean.getZxsRewardContent();
//			String rewardEffectiveDate = reqPbocAppBean.getZxsRewardEffecDate();
//			String rewardEndDate = reqPbocAppBean.getZxsRewardDeadline();
//			// 2.32车辆交易和抵押记录（列表）
//			String carPId = sequenceService.getSequence();
//			String carFId = reportId;
//			String carSn = reqPbocAppBean.getZxsVehicleRecordNo();
//			String carCardNumber = reqPbocAppBean.getZxsVehicleRecordLicensePlateNum();
//			String carEngineNumber = reqPbocAppBean.getZxsVehicleRecordEngineNum();
//			String carBrand = reqPbocAppBean.getZxsVehicleRecordBrand();
//			String carCardType = reqPbocAppBean.getZxsVehicleRecordType();
//			String carUseAttr = reqPbocAppBean.getZxsVehicleRecordUsePurpose();
//			String carCardStatus = reqPbocAppBean.getZxsVehicleRecordStatus();
//			String carPledgeStatus = reqPbocAppBean.getZxsVehicleRecordMortgageFlag();
//			String carNewsUpdateDate = reqPbocAppBean.getZxsVehicleRecordRecordUpdate();
//			// 2.33电信缴费记录（列表）
//			String telecomPId = sequenceService.getSequence();
//			String telecomFId = reportId;
//			String telecomSn = reqPbocAppBean.getZxsTelePayNo();
//			String telecomTelecomCompany = reqPbocAppBean.getZxsTelePayOperator();
//			String telecomBusinessType = reqPbocAppBean.getZxsTelePayBusinessType();
//			String telecomBusinessOpenDate = reqPbocAppBean.getZxsTelePayBusinessStartDate();
//			String telecomPaymenyStatus = reqPbocAppBean.getZxsTelePayCurrentStatus();
//			String telecomPostageDue = reqPbocAppBean.getZxsTelePayCurrentOweAmt();
//			String telecomPostageMonths = reqPbocAppBean.getZxsTelePayCurrentOweMonths();
//			String telecomAccountingDate = reqPbocAppBean.getZxsTelePayAccountYears();
//			String telecomMonth24status = reqPbocAppBean.getZxsTelePay24mMonthlyPayment();
//			// 2.34本人声明（列表）
//			String descriptionPId = sequenceService.getSequence();
//			String descriptionFId = reportId;
//			String descriptionSn = reqPbocAppBean.getZxsDeclareNo();
//			String descriptionDescriptionContent = reqPbocAppBean.getZxsDeclareContent();
//			String descriptionUpdateDate = reqPbocAppBean.getZxsDeclareAddDate();
//			String descriptionTableStyle = "本人声明";
//			// 2.35异议标注（列表）
//			String dissentPId = sequenceService.getSequence();
//			String dissentFId = reportId;
//			String dissentSn = reqPbocAppBean.getZxsObjectionMarkNo();
//			String dissentDescriptionContent = reqPbocAppBean.getZxsObjectionMarkContent();
//			String dissentUpdateDate = reqPbocAppBean.getZxsObjectionMarkAddDate();
//			String dissentTableStyle = "异议标注";
//			// 2.36查询记录汇总信息
//			String creditquerySummaryPId = sequenceService.getSequence();
//			String creditquerySummaryFId = reportId;
//			String creditquerySummaryLoadQueryOrganizations = reqPbocAppBean.getZxsRcy1MLoanQueryCompanyCnt();
//			String creditquerySummaryCreditQueryOrganizations = reqPbocAppBean.getZxsRcy1MCreCardQueryCompanyCnt();
//			String creditquerySummaryLoadQueryTimes = reqPbocAppBean.getZxsRcy1MLoanQueryCnt();
//			String creditquerySummaryCreditQueryTimes = reqPbocAppBean.getZxsRcy1MCreCardQueryCnt();
//			String creditquerySummaryPersonalQueryTimes = reqPbocAppBean.getZxsRcy1MQuerCnt();
//			String creditquerySummaryAffterLoadManage = reqPbocAppBean.getZxsRcy2YearsLoanMangeSum();
//			String creditquerySummaryBondsApprove = reqPbocAppBean.getZxsRcy2YearsGuarApproSum();
//			String creditquerySummarySpecialMerchant = reqPbocAppBean.getZxsRcy2YearsSpecialQuerySum();
//			// 2.37信贷审批查询记录明细（列表）
//			String creditqueryDetailPId = sequenceService.getSequence();
//			String creditqueryDetailReportId = reportId;
//			String creditqueryDetailSn = reqPbocAppBean.getZxsCreditApproveQueryDetailNo();
//			String creditqueryDetailQueryDate = reqPbocAppBean.getZxsCreditApproveQueryDetaiDate();
//			String creditqueryDetailQueryUser = reqPbocAppBean.getZxsCreditApproveQueryDetaiOperator();
//			String creditqueryDetailQueryReason = reqPbocAppBean.getZxsCreditApproveQueryDetaiReason();
//			// 3.调用中台服务
//			// 3.1插入查询基本信息表
//			QueryReportVO queryReportVO = new QueryReportVO();
//			queryReportVO.setReportId(reportId.equals("-9999") ? "" : reportId);
//			queryReportVO.setRequestTime(requestTime.equals("1900.01.01") ? "" : requestTime);
//			queryReportVO.setReportTime(reportTime.equals("1900.01.01") ? "" : reportTime);
//			queryReportVO.setCername(cername.equals("-9999") ? "" : cername);
//			queryReportVO.setCertype(certype.equals("-9999") ? "" : certype);
//			queryReportVO.setCercode(cercode.equals("-9999") ? "" : cercode);
//			queryReportVO.setUser(user.equals("-9999") ? "" : user);
//			queryReportVO.setQueryReason(queryReason.equals("-9999") ? "" : queryReason);
//			queryReportService.insertQueryReport(queryReportVO);
//			// 3.2插入身份信息表
//			PbocIdentityVO pbocIdentityVO = new PbocIdentityVO();
//			pbocIdentityVO.setPId(identityPId);
//			pbocIdentityVO.setFId(identityFId.equals("-9999") ? "" : identityFId);
//			pbocIdentityVO.setSex(identitysex.equals("-9999") ? "" : identitysex);
//			pbocIdentityVO.setBirth(identityBirth.equals("-9999") ? "" : identityBirth);
//			pbocIdentityVO.setMarriage(identityMarriage.equals("-9999||--") ? "" : identityMarriage);
//			pbocIdentityVO.setTelephone(identityTelephone.equals("-9999") ? "" : identityTelephone);
//			pbocIdentityVO.setTeleCompany(identityTeleCompany.equals("-9999") ? "" : identityTeleCompany);
//			pbocIdentityVO.setTeleHome(identityTeleHome.equals("-9999") ? "" : identityTeleHome);
//			pbocIdentityVO.setEducation(identityEducation.equals("-9999") ? "" : identityEducation);
//			pbocIdentityVO.setDegree(identityDegree.equals("-9999") ? "" : identityDegree);
//			pbocIdentityVO.setCommunicationAddr(identityCommunicationAddr.equals("-9999") ? "" : identityCommunicationAddr);
//			pbocIdentityVO.setHouseholdAddr(identityHouseholdAddr.equals("-9999") ? "" : identityHouseholdAddr);
//			pbocIdentityService.insertPbocIdentity(pbocIdentityVO);
//			// 3.3插入居住信息表
//			PbocResidenceVO pbocResidenceVO = new PbocResidenceVO();
//			String[] residenceSns = residenceSn.split("|+|");
//			String[] residenceAddresses = residenceAddress.split("|+|");
//			String[] residenceAddrStatuses = residenceAddrStatus.split("|+|");
//			String[] residenceUpdateDates = residenceUpdateDate.split("|+|");
//			for (int i = 0; i < residenceSns.length; i++) {
//				pbocResidenceVO.setPId(residencePId);
//				pbocResidenceVO.setFId(residenceFId.equals("-9999") ? "" : residenceFId);
//				pbocResidenceVO.setSn(residenceSns[i].equals("-9999") ? "" : residenceSns[i]);
//				pbocResidenceVO.setAddress(residenceAddresses[i].equals("-9999") ? "" : residenceAddresses[i]);
//				pbocResidenceVO.setAddrStatus(residenceAddrStatuses[i].equals("-9999") ? "" : residenceAddrStatuses[i]);
//				pbocResidenceVO.setUpdateDate(residenceUpdateDates[i].equals("-9999") ? "" : residenceUpdateDates[i]);
//				pbocResidenceService.insertPbocResidence(pbocResidenceVO);
//			}
//			// 3.4插入职业信息表
//			PbocJobVO pbocJobVO = new PbocJobVO();
//			String[] jobSns = jobSn.split("|+|");
//			String[] jobCompanys = jobCompany.split("|+|");
//			String[] jobAddresses = jobAddress.split("|+|");
//			String[] jobProfessions = jobProfession.split("|+|");
//			String[] jobTrades = jobTrade.split("|+|");
//			String[] jobPosts = jobPost.split("|+|");
//			String[] jobPostTitles = jobPostTitle.split("|+|");
//			String[] jobInComYears = jobInComYear.split("|+|");
//			String[] jobUpdateDates = jobUpdateDate.split("|+|");
//			for (int i = 0; i < jobSns.length; i++) {
//				pbocJobVO.setPId(jobPId);
//				pbocJobVO.setFId(jobFId.equals("-9999") ? "" : jobFId);
//				pbocJobVO.setSn(jobSns[i].equals("-9999") ? "" : jobSns[i]);
//				pbocJobVO.setCompany(jobCompanys[i].equals("-9999") ? "" : jobCompanys[i]);
//				pbocJobVO.setAddress(jobAddresses[i].equals("-9999") ? "" : jobAddresses[i]);
//				pbocJobVO.setProfession(jobProfessions[i].equals("-9999") ? "" : jobProfessions[i]);
//				pbocJobVO.setTrade(jobTrades[i].equals("-9999") ? "" : jobTrades[i]);
//				pbocJobVO.setPost(jobPosts[i].equals("-9999") ? "" : jobPosts[i]);
//				pbocJobVO.setPostTitle(jobPostTitles[i].equals("-9999") ? "" : jobPostTitles[i]);
//				pbocJobVO.setInComYear(jobInComYears[i].equals("-9999") ? "" : jobInComYears[i]);
//				pbocJobVO.setUpdateDate(jobUpdateDates[i].equals("-9999") ? "" : jobUpdateDates[i]);
//				pbocJobService.insertPbocJob(pbocJobVO);
//			}
//			// 3.5插入 信用提示信息表
//			PbocCreditPromptVO pbocCreditPromptVO = new PbocCreditPromptVO();
//			pbocCreditPromptVO.setPId(creditPromptPId);
//			pbocCreditPromptVO.setFId(creditPromptFId.equals("-9999") ? "" : creditPromptFId);
//			pbocCreditPromptVO.setHouseLoadNum(creditPromptHouseLoadNum.equals("-9999") ? "" : creditPromptHouseLoadNum);
//			pbocCreditPromptVO
//					.setBusHouseloadNum(creditPromptBusHouseloadNum.equals("-9999") ? "" : creditPromptBusHouseloadNum);
//			pbocCreditPromptVO.setOtherLoadNum(creditPromptOtherLoadNum.equals("-9999") ? "" : creditPromptOtherLoadNum);
//			pbocCreditPromptVO
//					.setFirstLoadMonth(creditPromptFirstLoadMonth.equals("-9999") ? "" : creditPromptFirstLoadMonth);
//			pbocCreditPromptVO
//					.setCreditAccounts(creditPromptCreditAccounts.equals("-9999") ? "" : creditPromptCreditAccounts);
//			pbocCreditPromptVO
//					.setFirstCreditMonth(creditPromptFirstCreditMonth.equals("-9999") ? "" : creditPromptFirstCreditMonth);
//			pbocCreditPromptVO.setNearcreditcardAccounts(
//					creditPromptNearcreditcardAccounts.equals("-9999") ? "" : creditPromptNearcreditcardAccounts);
//			pbocCreditPromptVO.setFirstNearcreditMonth(
//					creditPromptFirstNearcreditMonth.equals("-9999") ? "" : creditPromptFirstNearcreditMonth);
//			pbocCreditPromptVO
//					.setDescriptionNum(creditPromptDescriptionNum.equals("-9999") ? "" : creditPromptDescriptionNum);
//			pbocCreditPromptVO.setDissentNum(creditPromptDissentNum.equals("-9999") ? "" : creditPromptDissentNum);
//			pbocCreditPromptService.insertPbocCreditPrompt(pbocCreditPromptVO);
//			// 3.6插入 呆账信息汇总表
//			PbocBadDebtsVO pbocBadDebtsVO = new PbocBadDebtsVO();
//			pbocBadDebtsVO.setPId(badDebtsPId);
//			pbocBadDebtsVO.setFId(badDebtsFId.equals("-9999") ? "" : badDebtsFId);
//			pbocBadDebtsVO.setBadDebtsNum(badDebtsBadDebtsNum.equals("-9999") ? "" : badDebtsBadDebtsNum);
//			pbocBadDebtsVO.setBadDebtsRemain(
//					String.valueOf(badDebtsBadDebtsRemain).equals("-9999") ? "" : String.valueOf(badDebtsBadDebtsRemain));
//			pbocBadDebtsVO.setAssetsNum(badDebtsAssetsNum.equals("-9999") ? "" : badDebtsAssetsNum);
//			pbocBadDebtsVO.setAssetsRemain(
//					String.valueOf(badDebtsAssetsRemain).equals("-9999") ? "" : String.valueOf(badDebtsAssetsRemain));
//			pbocBadDebtsVO.setSponsorialNum(badDebtsSponsorialNum.equals("-9999") ? "" : badDebtsSponsorialNum);
//			pbocBadDebtsVO.setSponsorialRemain(String.valueOf(badDebtsSponsorialRemain).equals("-9999") ? ""
//					: String.valueOf(badDebtsSponsorialRemain));
//			pbocBadDebtsService.insertPbocBadDebts(pbocBadDebtsVO);
//			// 3.7插入逾期（透支）信息汇总表
//			PbocDeliverySumVO pbocDeliverySumVO = new PbocDeliverySumVO();
//			pbocDeliverySumVO.setPId(deliverySumPId);
//			pbocDeliverySumVO.setFId(deliverySumFId.equals("-9999") ? "" : deliverySumFId);
//			pbocDeliverySumVO.setLoadOverdueNum(deliverySumLoadOverdueNum.equals("-9999") ? "" : deliverySumLoadOverdueNum);
//			pbocDeliverySumVO
//					.setLoadOverdueMonths(deliverySumLoadOverdueMonths.equals("-9999") ? "" : deliverySumLoadOverdueMonths);
//			pbocDeliverySumVO.setCreditOverdueMaxSum(String.valueOf(deliverySumLoadOverdueMaxSum).equals("-9999") ? ""
//					: String.valueOf(deliverySumLoadOverdueMaxSum));
//			pbocDeliverySumVO.setLoadOverdueMaxMonth(
//					deliverySumLoadOverdueMaxMonth.equals("-9999") ? "" : deliverySumLoadOverdueMaxMonth);
//			pbocDeliverySumVO.setCreditOverdueAccounts(
//					deliverySumCreditOverdueAccounts.equals("-9999") ? "" : deliverySumCreditOverdueAccounts);
//			pbocDeliverySumVO.setCreditOverdueMonths(String.valueOf(deliverySumCreditOverdueMonths).equals("-9999") ? ""
//					: String.valueOf(deliverySumCreditOverdueMonths));
//			pbocDeliverySumVO.setCreditOverdueMaxSum(String.valueOf(deliverySumCreditOverdueMaxSum).equals("-9999") ? ""
//					: String.valueOf(deliverySumCreditOverdueMaxSum));
//			pbocDeliverySumVO.setCreditOverdueMaxMonth(
//					deliverySumCreditOverdueMaxMonth.equals("-9999") ? "" : deliverySumCreditOverdueMaxMonth);
//			pbocDeliverySumVO.setNearcredit60dAccounts(
//					deliverySumNearcredit60dAccounts.equals("-9999") ? "" : deliverySumNearcredit60dAccounts);
//			pbocDeliverySumVO.setNearcredit60dMonths(
//					deliverySumNearcredit60dMonths.equals("-9999") ? "" : deliverySumNearcredit60dMonths);
//			pbocDeliverySumVO.setNearcredit60dMaxSum(
//					deliverySumNearcredit60dMaxSum.equals("-9999") ? "" : deliverySumNearcredit60dMaxSum);
//			pbocDeliverySumVO.setNearcredit60dMaxMonth(
//					deliverySumNearcredit60dMaxMonth.equals("-9999") ? "" : deliverySumNearcredit60dMaxMonth);
//			pbocDeliverySumService.insertPbocDeliverySum(pbocDeliverySumVO);
//			// 3.8插入未结清贷款信息汇总表
//			PbocNoneSettleVO pbocNoneSettleVO = new PbocNoneSettleVO();
//			pbocNoneSettleVO.setPId(noneSettlePId);
//			pbocNoneSettleVO.setFId(noneSettleFId.equals("-9999") ? "" : noneSettleFId);
//			pbocNoneSettleVO
//					.setLoadCorporationNum(noneSettleLoadCorporationNum.equals("-9999") ? "" : noneSettleLoadCorporationNum);
//			pbocNoneSettleVO.setLoadOrganizationNum(
//					noneSettleLoadOrganizationNum.equals("-9999") ? "" : noneSettleLoadOrganizationNum);
//			pbocNoneSettleVO.setNum(noneSettleNum.equals("-9999") ? "" : noneSettleNum);
//			pbocNoneSettleVO.setContractSum(
//					String.valueOf(noneSettleContractSum).equals("-9999") ? "" : String.valueOf(noneSettleContractSum));
//			pbocNoneSettleVO
//					.setRemain(String.valueOf(noneSettleRemain).equals("-9999") ? "" : String.valueOf(noneSettleRemain));
//			pbocNoneSettleVO.setLast6mRepay(
//					String.valueOf(noneSettleLast6mRepay).equals("-9999") ? "" : String.valueOf(noneSettleLast6mRepay));
//			pbocNoneSettleService.insertPbocNoneSettle(pbocNoneSettleVO);
//			// 3.9插入未销户贷记卡信息汇总表
//			PbocNoneworkoffCreditcardVO pbocNoneworkoffCreditcardVO = new PbocNoneworkoffCreditcardVO();
//			pbocNoneworkoffCreditcardVO.setPId(noneworkoffCreditcardPId);
//			pbocNoneworkoffCreditcardVO.setFId(noneworkoffCreditcardFId.equals("-9999") ? "" : noneworkoffCreditcardFId);
//			pbocNoneworkoffCreditcardVO
//					.setIssuingCorporationNum(noneworkoffCreditcardIssuingCorporationNum.equals("-9999") ? ""
//							: noneworkoffCreditcardIssuingCorporationNum);
//			pbocNoneworkoffCreditcardVO
//					.setIssuingOrganizationNum(noneworkoffCreditcardIssuingOrganizationNum.equals("-9999") ? ""
//							: noneworkoffCreditcardIssuingOrganizationNum);
//			pbocNoneworkoffCreditcardVO.setAccounts(String.valueOf(noneworkoffCreditcardAccounts).equals("-9999") ? ""
//					: String.valueOf(noneworkoffCreditcardAccounts));
//			pbocNoneworkoffCreditcardVO
//					.setExtensionSum(String.valueOf(noneworkoffCreditcardExtensionSum).equals("-9999") ? ""
//							: String.valueOf(noneworkoffCreditcardExtensionSum));
//			pbocNoneworkoffCreditcardVO
//					.setSingleMaxExtension(String.valueOf(noneworkoffCreditcardSingleMaxExtension).equals("-9999") ? ""
//							: String.valueOf(noneworkoffCreditcardSingleMaxExtension));
//			pbocNoneworkoffCreditcardVO
//					.setSingleMinExtension(String.valueOf(noneworkoffCreditcardSingleMinExtension).equals("-9999") ? ""
//							: String.valueOf(noneworkoffCreditcardSingleMinExtension));
//			pbocNoneworkoffCreditcardVO
//					.setUsedExtension(String.valueOf(noneworkoffCreditcardUsedExtension).equals("-9999") ? ""
//							: String.valueOf(noneworkoffCreditcardUsedExtension));
//			pbocNoneworkoffCreditcardVO.setLast6mAvgUsedextension(
//					String.valueOf(noneworkoffCreditcardLast6mAvgUsedextension).equals("-9999") ? ""
//							: String.valueOf(noneworkoffCreditcardLast6mAvgUsedextension));
//			pbocNoneworkoffCreditcardService.insertPbocNoneworkoffCreditcard(pbocNoneworkoffCreditcardVO);
//			// 3.10插入未销户准贷记卡信息汇总表
//			PbocNoneworkoffNearcreditcardVO pbocNoneworkoffNearcreditcardVO = new PbocNoneworkoffNearcreditcardVO();
//			pbocNoneworkoffNearcreditcardVO.setPId(noneworkoffNearcreditcardPId);
//			pbocNoneworkoffNearcreditcardVO.setFId(noneworkoffNearcreditcardFId);
//			pbocNoneworkoffNearcreditcardVO.setIssuingCorporationNum(noneworkoffNearcreditcardIssuingCorporationNum);
//			pbocNoneworkoffNearcreditcardVO.setIssuingOrganizationNum(noneworkoffNearcreditcardIssuingOrganizationNum);
//			pbocNoneworkoffNearcreditcardVO.setAccounts(noneworkoffNearcreditcardAccounts);
//			pbocNoneworkoffNearcreditcardVO.setExtensionSum(noneworkoffNearcreditcardExtensionSum);
//			pbocNoneworkoffNearcreditcardVO.setSingleMaxExtension(noneworkoffNearcreditcardSingleMaxExtension);
//			pbocNoneworkoffNearcreditcardVO.setSingleMinExtension(noneworkoffNearcreditcardSingleMinExtension);
//			pbocNoneworkoffNearcreditcardVO.setUsedExtension(noneworkoffNearcreditcardUsedExtension);
//			pbocNoneworkoffNearcreditcardVO.setLast6mAvgUsedextension(noneworkoffNearcreditcardLast6mAvgUsedextension);
//			pbocNoneworkoffNearcreditcardService.insertPbocNoneworkoffNearcreditcard(pbocNoneworkoffNearcreditcardVO);
//			// 3.11插入对外担保信息汇总表
//			PbocBondsmanVO pbocBondsmanVO = new PbocBondsmanVO();
//			pbocBondsmanVO.setPId(bondsmanPId);
//			pbocBondsmanVO.setFId(bondsmanFId.equals("-9999") ? "" : bondsmanFId);
//			pbocBondsmanVO.setSecuredNum(bondsmanSecuredNum.equals("-9999") ? "" : bondsmanSecuredNum);
//			pbocBondsmanVO.setSeceredMoney(
//					String.valueOf(bondsmanSeceredMoney).equals("-9999") ? "" : String.valueOf(bondsmanSeceredMoney));
//			pbocBondsmanVO.setSeceredCapital(
//					String.valueOf(bondsmanSeceredCapital).equals("-9999") ? "" : String.valueOf(bondsmanSeceredCapital));
//			pbocBondsmanService.insertPbocBondsman(pbocBondsmanVO);
//			// 3.12插入资产处置信息表
//			PbocAssetDetailVO pbocAssetDetailVO = new PbocAssetDetailVO();
//			String[] assetDetailSns = assetDetailSn.split("|+|");
//			String[] assetDetailAssetManageCompanys = assetDetailAssetManageCompany.split("|+|");
//			String[] assetDetailRecipientDates = assetDetailRecipientDate.split("|+|");
//			String[] assetDetailRecipientAmounts = assetDetailRecipientAmount.split("|+|");
//			String[] assetDetailLastRepayDates = assetDetailLastRepayDate.split("|+|");
//			String[] assetDetailRemains = assetDetailRemain.split("|+|");
//			for (int i = 0; i < assetDetailSns.length; i++) {
//				pbocAssetDetailVO.setPId(assetDetailPId);
//				pbocAssetDetailVO.setFId(assetDetailFId.equals("-9999") ? "" : assetDetailFId);
//				pbocAssetDetailVO.setSn(assetDetailSns[i].equals("-9999") ? "" : assetDetailSns[i]);
//				pbocAssetDetailVO.setAssetManageCompany(
//						assetDetailAssetManageCompanys[i].equals("-9999") ? "" : assetDetailAssetManageCompanys[i]);
//				pbocAssetDetailVO
//						.setRecipientDate(assetDetailRecipientDates[i].equals("-9999") ? "" : assetDetailRecipientDates[i]);
//				pbocAssetDetailVO.setRecipientAmount(
//						assetDetailRecipientAmounts[i].equals("-9999") ? "" : assetDetailRecipientAmounts[i]);
//				pbocAssetDetailVO
//						.setLastRepayDate(assetDetailLastRepayDates[i].equals("-9999") ? "" : assetDetailLastRepayDates[i]);
//				pbocAssetDetailVO.setRemain(assetDetailRemains[i].equals("-9999") ? "" : assetDetailRemains[i]);
//				pbocAssetDetailService.insertPbocAssetDetail(pbocAssetDetailVO);
//			}
//			// 3.13插入保证人代偿信息表
//			PbocSponsorialDetailVO pbocSponsorialDetailVO = new PbocSponsorialDetailVO();
//			String[] sponsorialDetailSns = sponsorialDetailSn.split("|+|");
//			String[] sponsorialDetailSponsorialOrganizations = sponsorialDetailSponsorialOrganization.split("|+|");
//			String[] sponsorialDetailReplaceRepayDates = sponsorialDetailReplaceRepayDate.split("|+|");
//			String[] sponsorialDetailReplaceRepaySums = sponsorialDetailReplaceRepaySum.split("|+|");
//			String[] sponsorialDetailLastRepayDates = sponsorialDetailLastRepayDate.split("|+|");
//			String[] sponsorialDetailRemains = sponsorialDetailRemain.split("|+|");
//			for (int i = 0; i < sponsorialDetailSns.length; i++) {
//				pbocSponsorialDetailVO.setPId(sponsorialDetailPId);
//				pbocSponsorialDetailVO.setFId(sponsorialDetailFId.equals("-9999") ? "" : sponsorialDetailFId);
//				pbocSponsorialDetailVO.setSn(sponsorialDetailSns[i].equals("-9999") ? "" : sponsorialDetailSns[i]);
//				pbocSponsorialDetailVO
//						.setSponsorialOrganization(sponsorialDetailSponsorialOrganizations[i].equals("-9999") ? ""
//								: sponsorialDetailSponsorialOrganizations[i]);
//				pbocSponsorialDetailVO.setReplaceRepayDate(
//						sponsorialDetailReplaceRepayDates[i].equals("-9999") ? "" : sponsorialDetailReplaceRepayDates[i]);
//				pbocSponsorialDetailVO.setReplaceRepaySum(
//						sponsorialDetailReplaceRepaySums[i].equals("-9999") ? "" : sponsorialDetailReplaceRepaySums[i]);
//				pbocSponsorialDetailVO.setLastRepayDate(
//						sponsorialDetailLastRepayDates[i].equals("-9999") ? "" : sponsorialDetailLastRepayDates[i]);
//				pbocSponsorialDetailVO
//						.setRemain(sponsorialDetailRemains[i].equals("-9999") ? "" : sponsorialDetailRemains[i]);
//				pbocSponsorialDetailService.insertPbocSponsorialDetail(pbocSponsorialDetailVO);
//			}
//			// 3.14插入贷款基本信息表
//			PbocLoadBasicVO pbocLoadBasicVO = new PbocLoadBasicVO();
//			String[] loadBasicBegDates = loadBasicBegDate.split("|+|");
//			String[] loadBasicOrganizationTypes = loadBasicOrganizationType.split("|+|");
//			String[] loadBasicOrganizationNames = loadBasicOrganizationName.split("|+|");
//			String[] loadBasicLoadAmounts = loadBasicLoadAmount.split("|+|");
//			String[] loadBasicCurrencys = loadBasicCurrency.split("|+|");
//			String[] loadBasicLoadTypes = loadBasicLoadType.split("|+|");
//			String[] loadBasicBusinessSns = loadBasicBusinessSn.split("|+|");
//			String[] loadBasicBondsTypes = loadBasicBondsType.split("|+|");
//			String[] loadBasicLoadPeriodses = loadBasicLoadPeriods.split("|+|");
//			String[] loadBasicRepayWays = loadBasicRepayWay.split("|+|");
//			String[] loadBasicEndDates = loadBasicEndDate.split("|+|");
//			String[] loadBasicUpdateDates = loadBasicUpdateDate.split("|+|");
//			String[] loadBasicLoadStatuses = loadBasicLoadStatus.split("|+|");
//			String[] loadBasicRemains = loadBasicRemain.split("|+|");
//			String[] loadBasicMonth24statuses = loadBasicMonth24status.split("|+|");
//			String[] loadBasicSns = loadBasicSn.split("|+|");
//			for (int i = 0; i < loadBasicSns.length; i++) {
//				pbocLoadBasicVO.setPId(loadBasicPId);
//				pbocLoadBasicVO.setFId(loadBasicFId.equals("-9999") ? "" : loadBasicFId);
//				pbocLoadBasicVO.setBegDate(loadBasicBegDates[i].equals("-9999") ? "" : loadBasicBegDates[i]);
//				pbocLoadBasicVO.setOrganizationType(
//						loadBasicOrganizationTypes[i].equals("-9999") ? "" : loadBasicOrganizationTypes[i]);
//				pbocLoadBasicVO.setOrganizationName(
//						loadBasicOrganizationNames[i].equals("-9999") ? "" : loadBasicOrganizationNames[i]);
//				pbocLoadBasicVO.setLoadAmount(loadBasicLoadAmounts[i].equals("-9999") ? "" : loadBasicLoadAmounts[i]);
//				pbocLoadBasicVO.setCurrency(loadBasicCurrencys[i].equals("-9999") ? "" : loadBasicCurrencys[i]);
//				pbocLoadBasicVO.setLoadType(loadBasicLoadTypes[i].equals("-9999") ? "" : loadBasicLoadTypes[i]);
//				pbocLoadBasicVO.setBusinessSn(loadBasicBusinessSns[i].equals("-9999") ? "" : loadBasicBusinessSns[i]);
//				pbocLoadBasicVO.setBondsType(loadBasicBondsTypes[i].equals("-9999") ? "" : loadBasicBondsTypes[i]);
//				pbocLoadBasicVO.setLoadPeriods(loadBasicLoadPeriodses[i].equals("-9999") ? "" : loadBasicLoadPeriodses[i]);
//				pbocLoadBasicVO.setRepayWay(loadBasicRepayWays[i].equals("-9999") ? "" : loadBasicRepayWays[i]);
//				pbocLoadBasicVO.setEndDate(loadBasicEndDates[i].equals("-9999") ? "" : loadBasicEndDates[i]);
//				pbocLoadBasicVO.setUpdateDate(loadBasicUpdateDates[i].equals("-9999") ? "" : loadBasicUpdateDates[i]);
//				pbocLoadBasicVO.setLoadStatus(loadBasicLoadStatuses[i].equals("-9999") ? "" : loadBasicLoadStatuses[i]);
//				pbocLoadBasicVO.setRemain(loadBasicRemains[i].equals("-9999") ? "" : loadBasicRemain);
//				pbocLoadBasicVO.setBegYearMonth(loadBasicBegYearMonth.equals("-9999") ? "" : loadBasicBegYearMonth);
//				pbocLoadBasicVO.setEndYearMonth(loadBasicEndYearMonth.equals("-9999") ? "" : loadBasicEndYearMonth);
//				pbocLoadBasicVO
//						.setMonth24status(loadBasicMonth24statuses[i].equals("-9999") ? "" : loadBasicMonth24statuses[i]);
//				pbocLoadBasicVO.setSn(loadBasicSns[i].equals("-9999") ? "" : loadBasicSns[i]);
//				pbocLoadBasicService.insertPbocLoadBasic(pbocLoadBasicVO);
//			}
//			// 3.15插入贷款状态信息表
//			PbocLoadStatusVO pbocLoadStatusVO = new PbocLoadStatusVO();
//			String[] loadStatusLoadStatuses = loadStatusLoadStatus.split("|+|");
//			String[] loadStatusFiveStyles = loadStatusFiveStyle.split("|+|");
//			String[] loadStatusBasicLoadAmounts = loadStatusBasicLoadAmount.split("|+|");
//			String[] loadStatusRemainLoadPeriodses = loadStatusRemainLoadPeriods.split("|+|");
//			String[] loadStatusRepayAtMonths = loadStatusRepayAtMonth.split("|+|");
//			String[] loadStatusNeedRepayDates = loadStatusNeedRepayDate.split("|+|");
//			String[] loadStatusRepayedAtMonths = loadStatusRepayedAtMonth.split("|+|");
//			String[] loadStatusLastRepayDates = loadStatusLastRepayDate.split("|+|");
//			for (int i = 0; i < loadStatusLoadStatuses.length; i++) {
//				pbocLoadStatusVO.setPId(loadStatusPId);
//				pbocLoadStatusVO.setFId(loadStatusFId.equals("-9999") ? "" : loadStatusFId);
//				pbocLoadStatusVO.setLoadStatus(loadStatusLoadStatuses[i].equals("-9999") ? "" : loadStatusLoadStatuses[i]);
//				pbocLoadStatusVO.setFiveStyle(loadStatusFiveStyles[i].equals("-9999") ? "" : loadStatusFiveStyles[i]);
//				pbocLoadStatusVO.setBasicLoadAmount(
//						loadStatusBasicLoadAmounts[i].equals("-9999") ? "" : loadStatusBasicLoadAmounts[i]);
//				pbocLoadStatusVO.setRemainLoadPeriods(
//						loadStatusRemainLoadPeriodses[i].equals("-9999") ? "" : loadStatusRemainLoadPeriodses[i]);
//				pbocLoadStatusVO
//						.setRepayAtMonth(loadStatusRepayAtMonths[i].equals("-9999") ? "" : loadStatusRepayAtMonths[i]);
//				pbocLoadStatusVO
//						.setNeedRepayDate(loadStatusNeedRepayDates[i].equals("-9999") ? "" : loadStatusNeedRepayDates[i]);
//				pbocLoadStatusVO
//						.setRepayedAtMonth(loadStatusRepayedAtMonths[i].equals("-9999") ? "" : loadStatusRepayedAtMonths[i]);
//				pbocLoadStatusVO
//						.setLastRepayDate(loadStatusLastRepayDates[i].equals("-9999") ? "" : loadStatusLastRepayDates[i]);
//				pbocLoadStatusService.insertPbocLoadStatus(pbocLoadStatusVO);
//			}
//			// 3.16插入贷款当前逾期信息表
//			PbocLoadOverdueVO pbocLoadOverdueVO = new PbocLoadOverdueVO();
//			String[] loadOverdueOverduePeriodses = loadOverdueOverduePeriods.split("|+|");
//			String[] loadOverdueOverdueAmounts = loadOverdueOverdueAmount.split("|+|");
//			String[] loadOverdueOverdue3160Amounts = loadOverdueOverdue3160Amount.split("|+|");
//			String[] loadOverdueOverdue6190Amounts = loadOverdueOverdue6190Amount.split("|+|");
//			String[] loadOverdueOverdue91180Amounts = loadOverdueOverdue91180Amount.split("|+|");
//			String[] loadOverdueOverdue180Amounts = loadOverdueOverdue180Amount.split("|+|");
//			for (int i = 0; i < loadOverdueOverduePeriodses.length; i++) {
//				pbocLoadOverdueVO.setPId(loadOverduePId);
//				pbocLoadOverdueVO.setFId(loadOverdueFId.equals("-9999") ? "" : loadOverdueFId);
//				pbocLoadOverdueVO.setOverduePeriods(
//						loadOverdueOverduePeriodses[i].equals("-9999") ? "" : loadOverdueOverduePeriodses[i]);
//				pbocLoadOverdueVO
//						.setOverdueAmount(loadOverdueOverdueAmounts[i].equals("-9999") ? "" : loadOverdueOverdueAmounts[i]);
//				pbocLoadOverdueVO.setOverdue3160Amount(
//						loadOverdueOverdue3160Amounts[i].equals("-9999") ? "" : loadOverdueOverdue3160Amounts[i]);
//				pbocLoadOverdueVO.setOverdue6190Amount(
//						loadOverdueOverdue6190Amounts[i].equals("-9999") ? "" : loadOverdueOverdue6190Amounts[i]);
//				pbocLoadOverdueVO.setOverdue91180Amount(
//						loadOverdueOverdue91180Amounts[i].equals("-9999") ? "" : loadOverdueOverdue91180Amounts[i]);
//				pbocLoadOverdueVO.setOverdue180Amount(
//						loadOverdueOverdue180Amounts[i].equals("-9999") ? "" : loadOverdueOverdue180Amounts[i]);
//				pbocLoadOverdueService.insertPbocLoadOverdue(pbocLoadOverdueVO);
//			}
//			// 3.17插入贷记卡基本信息表
//			PbocCreditBasicVO pbocCreditBasicVO = new PbocCreditBasicVO();
//			String[] creditBasicBegDates = creditBasicBegDate.split("|+|");
//			String[] creditBasicOrganizationTypes = creditBasicOrganizationType.split("|+|");
//			String[] creditBasicOrganizationNames = creditBasicOrganizationName.split("|+|");
//			String[] creditBasicCurrencys = creditBasicCurrency.split("|+|");
//			String[] creditBasicBusinessSns = creditBasicBusinessSn.split("|+|");
//			String[] creditBasicExtensions = creditBasicExtension.split("|+|");
//			String[] creditBasicExtensionShares = creditBasicExtensionShare.split("|+|");
//			String[] creditBasicBondsTypes = creditBasicBondsType.split("|+|");
//			String[] creditBasicUpdateDates = creditBasicUpdateDate.split("|+|");
//			String[] creditBasicCreditStatuses = creditBasicCreditStatus.split("|+|");
//			String[] creditBasicRemains = creditBasicRemain.split("|+|");
//			String[] creditBasicMonth24statuses = creditBasicMonth24status.split("|+|");
//			String[] creditBasicSns = creditBasicSn.split("|+|");
//			for (int i = 0; i < creditBasicSns.length; i++) {
//				pbocCreditBasicVO.setPId(creditBasicPId);
//				pbocCreditBasicVO.setFId(creditBasicFId.equals("-9999") ? "" : creditBasicFId);
//				pbocCreditBasicVO.setBegDate(creditBasicBegDates[i].equals("-9999") ? "" : creditBasicBegDates[i]);
//				pbocCreditBasicVO.setOrganizationType(
//						creditBasicOrganizationTypes[i].equals("-9999") ? "" : creditBasicOrganizationTypes[i]);
//				pbocCreditBasicVO.setOrganizationName(
//						creditBasicOrganizationNames[i].equals("-9999") ? "" : creditBasicOrganizationNames[i]);
//				pbocCreditBasicVO.setCurrency(creditBasicCurrencys[i].equals("-9999") ? "" : creditBasicCurrencys[i]);
//				pbocCreditBasicVO.setBusinessSn(creditBasicBusinessSns[i].equals("-9999") ? "" : creditBasicBusinessSns[i]);
//				pbocCreditBasicVO.setExtension(creditBasicExtensions[i].equals("-9999") ? "" : creditBasicExtensions[i]);
//				pbocCreditBasicVO.setExtensionShare(
//						creditBasicExtensionShares[i].equals("-9999") ? "" : creditBasicExtensionShares[i]);
//				pbocCreditBasicVO.setBondsType(creditBasicBondsTypes[i].equals("-9999") ? "" : creditBasicBondsTypes[i]);
//				pbocCreditBasicVO.setUpdateDate(creditBasicUpdateDates[i].equals("-9999") ? "" : creditBasicUpdateDates[i]);
//				pbocCreditBasicVO
//						.setCreditStatus(creditBasicCreditStatuses[i].equals("-9999") ? "" : creditBasicCreditStatuses[i]);
//				pbocCreditBasicVO.setRemain(creditBasicRemains[i].equals("-9999") ? "" : creditBasicRemains[i]);
//				pbocCreditBasicVO.setCreditType(creditBasicCreditType.equals("-9999") ? "" : creditBasicCreditType);
//				pbocCreditBasicVO.setBegYearMonth(creditBasicBegYearMonth.equals("-9999") ? "" : creditBasicBegYearMonth);
//				pbocCreditBasicVO.setEndYearMonth(creditBasicEndYearMonth.equals("-9999") ? "" : creditBasicEndYearMonth);
//				pbocCreditBasicVO.setMonth24status(
//						creditBasicMonth24statuses[i].equals("-9999") ? "" : creditBasicMonth24statuses[i]);
//				pbocCreditBasicVO.setSn(creditBasicSns[i].equals("-9999") ? "" : creditBasicSns[i]);
//				pbocCreditBasicService.insertPbocCreditBasic(pbocCreditBasicVO);
//			}
//			// 3.18插入贷记卡状态信息表
//			PbocCreditStatusVO pbocCreditStatusVO = new PbocCreditStatusVO();
//			String[] creditStatusCreditStatuses = creditStatusCreditStatus.split("|+|");
//			String[] creditStatusUsedAmounts = creditStatusUsedAmount.split("|+|");
//			String[] creditStatusLast6monthAvgs = creditStatusLast6monthAvg.split("|+|");
//			String[] creditStatusMaxUsedAmounts = creditStatusMaxUsedAmount.split("|+|");
//			String[] creditStatusRepayAtMonths = creditStatusRepayAtMonth.split("|+|");
//			String[] creditStatusBillDates = creditStatusBillDate.split("|+|");
//			String[] creditStatusRepayedAtMonths = creditStatusRepayedAtMonth.split("|+|");
//			String[] creditStatusLastRepayDates = creditStatusLastRepayDate.split("|+|");
//			String[] creditStatusOverduePeriodses = creditStatusOverduePeriods.split("|+|");
//			String[] creditStatusOverdueAmounts = creditStatusOverdueAmount.split("|+|");
//			for (int i = 0; i < creditBasicSns.length; i++) {
//				pbocCreditStatusVO.setPId(creditStatusPId);
//				pbocCreditStatusVO.setFId(creditStatusFId.equals("-9999") ? "" : creditStatusFId);
//				pbocCreditStatusVO
//						.setCreditStatus(creditStatusCreditStatuses[i].equals("-9999") ? "" : creditStatusCreditStatuses[i]);
//				pbocCreditStatusVO
//						.setUsedAmount(creditStatusUsedAmounts[i].equals("-9999") ? "" : creditStatusUsedAmounts[i]);
//				pbocCreditStatusVO.setLast6monthAvg(
//						creditStatusLast6monthAvgs[i].equals("-9999") ? "" : creditStatusLast6monthAvgs[i]);
//				pbocCreditStatusVO.setMaxUsedAmount(
//						creditStatusMaxUsedAmounts[i].equals("-9999") ? "" : creditStatusMaxUsedAmounts[i]);
//				pbocCreditStatusVO
//						.setRepayAtMonth(creditStatusRepayAtMonths[i].equals("-9999") ? "" : creditStatusRepayAtMonths[i]);
//				pbocCreditStatusVO.setBillDate(creditStatusBillDates[i].equals("-9999") ? "" : creditStatusBillDates[i]);
//				pbocCreditStatusVO.setRepayedAtMonth(
//						creditStatusRepayedAtMonths[i].equals("-9999") ? "" : creditStatusRepayedAtMonths[i]);
//				pbocCreditStatusVO.setLastRepayDate(
//						creditStatusLastRepayDates[i].equals("-9999") ? "" : creditStatusLastRepayDates[i]);
//				pbocCreditStatusVO.setOverduePeriods(
//						creditStatusOverduePeriodses[i].equals("-9999") ? "" : creditStatusOverduePeriodses[i]);
//				pbocCreditStatusVO.setOverdueAmount(
//						creditStatusOverdueAmounts[i].equals("-9999") ? "" : creditStatusOverdueAmounts[i]);
//				pbocCreditStatusService.insertPbocCreditStatus(pbocCreditStatusVO);
//			}
//			// 3.19插入准贷记卡基本信息表
//			String[] nearCreditBasicBegDates = nearCreditBasicBegDate.split("|+|");
//			String[] nearCreditBasicOrganizationTypes = nearCreditBasicOrganizationType.split("|+|");
//			String[] nearCreditBasicOrganizationNames = nearCreditBasicOrganizationName.split("|+|");
//			String[] nearCreditBasicCurrencys = nearCreditBasicCurrency.split("|+|");
//			String[] nearCreditBasicBusinessSns = nearCreditBasicBusinessSn.split("|+|");
//			String[] nearCreditBasicExtensions = nearCreditBasicExtension.split("|+|");
//			String[] nearCreditBasicExtensionShares = nearCreditBasicExtensionShare.split("|+|");
//			String[] nearCreditBasicBondsTypes = nearCreditBasicBondsType.split("|+|");
//			String[] nearCreditBasicUpdateDates = nearCreditBasicUpdateDate.split("|+|");
//			String[] nearCreditBasicCreditStatuses = nearCreditBasicCreditStatus.split("|+|");
//			String[] nearCreditBasicRemains = nearCreditBasicRemain.split("|+|");
//			String[] nearCreditBasicMonth24statuses = nearCreditBasicMonth24status.split("|+|");
//			String[] nearCreditBasicSns = nearCreditBasicSn.split("|+|");
//			for (int i = 0; i < nearCreditBasicSns.length; i++) {
//				pbocCreditBasicVO.setPId(nearCreditBasicPId);
//				pbocCreditBasicVO.setFId(nearCreditBasicFId.equals("-9999") ? "" : nearCreditBasicFId);
//				pbocCreditBasicVO.setBegDate(nearCreditBasicBegDates[i].equals("-9999") ? "" : nearCreditBasicBegDates[i]);
//				pbocCreditBasicVO.setOrganizationType(
//						nearCreditBasicOrganizationTypes[i].equals("-9999") ? "" : nearCreditBasicOrganizationTypes[i]);
//				pbocCreditBasicVO.setOrganizationName(
//						nearCreditBasicOrganizationNames[i].equals("-9999") ? "" : nearCreditBasicOrganizationNames[i]);
//				pbocCreditBasicVO
//						.setCurrency(nearCreditBasicCurrencys[i].equals("-9999") ? "" : nearCreditBasicCurrencys[i]);
//				pbocCreditBasicVO
//						.setBusinessSn(nearCreditBasicBusinessSns[i].equals("-9999") ? "" : nearCreditBasicBusinessSns[i]);
//				pbocCreditBasicVO
//						.setExtension(nearCreditBasicExtensions[i].equals("-9999") ? "" : nearCreditBasicExtensions[i]);
//				pbocCreditBasicVO.setExtensionShare(
//						nearCreditBasicExtensionShares[i].equals("-9999") ? "" : nearCreditBasicExtensionShares[i]);
//				pbocCreditBasicVO
//						.setBondsType(nearCreditBasicBondsTypes[i].equals("-9999") ? "" : nearCreditBasicBondsTypes[i]);
//				pbocCreditBasicVO
//						.setUpdateDate(nearCreditBasicUpdateDates[i].equals("-9999") ? "" : nearCreditBasicUpdateDates[i]);
//				pbocCreditBasicVO.setCreditStatus(
//						nearCreditBasicCreditStatuses[i].equals("-9999") ? "" : nearCreditBasicCreditStatuses[i]);
//				pbocCreditBasicVO.setRemain(nearCreditBasicRemains[i].equals("-9999") ? "" : nearCreditBasicRemains[i]);
//				pbocCreditBasicVO.setCreditType(nearCreditBasicCreditType.equals("-9999") ? "" : nearCreditBasicCreditType);
//				pbocCreditBasicVO
//						.setBegYearMonth(nearCreditBasicBegYearMonth.equals("-9999") ? "" : nearCreditBasicBegYearMonth);
//				pbocCreditBasicVO
//						.setEndYearMonth(nearCreditBasicEndYearMonth.equals("-9999") ? "" : nearCreditBasicEndYearMonth);
//				pbocCreditBasicVO.setMonth24status(
//						nearCreditBasicMonth24statuses[i].equals("-9999") ? "" : nearCreditBasicMonth24statuses[i]);
//				pbocCreditBasicVO.setSn(nearCreditBasicSns[i].equals("-9999") ? "" : nearCreditBasicSns[i]);
//				pbocCreditBasicService.insertPbocCreditBasic(pbocCreditBasicVO);
//			}
//			// 3.20插入准贷记卡状态信息表
//			PbocNearcreditStatusVO pbocNearcreditStatusVO = new PbocNearcreditStatusVO();
//			String[] nearCreditStatusNearcreditStatuses = nearCreditStatusNearcreditStatus.split("|+|");
//			String[] nearCreditStatusUsedAmounts = nearCreditStatusUsedAmount.split("|+|");
//			String[] nearCreditStatusLast6monthAvgs = nearCreditStatusLast6monthAvg.split("|+|");
//			String[] nearCreditStatusMaxUsedAmounts = nearCreditStatusMaxUsedAmount.split("|+|");
//			String[] nearCreditStatusBillDates = nearCreditStatusBillDate.split("|+|");
//			String[] nearCreditStatusRepayedAtMonths = nearCreditStatusRepayedAtMonth.split("|+|");
//			String[] nearCreditStatusLastRepayDates = nearCreditStatusLastRepayDate.split("|+|");
//			String[] nearCreditStatusOverdue180dAmounts = nearCreditStatusOverdue180dAmount.split("|+|");
//			for (int i = 0; i < nearCreditBasicSns.length; i++) {
//				pbocNearcreditStatusVO.setPId(nearCreditStatusPId);
//				pbocNearcreditStatusVO.setFId(nearCreditStatusFId.equals("-9999") ? "" : nearCreditStatusFId);
//				pbocNearcreditStatusVO.setNearcreditStatus(
//						nearCreditStatusNearcreditStatuses[i].equals("-9999") ? "" : nearCreditStatusNearcreditStatuses[i]);
//				pbocNearcreditStatusVO
//						.setUsedAmount(nearCreditStatusUsedAmounts[i].equals("-9999") ? "" : nearCreditStatusUsedAmounts[i]);
//				pbocNearcreditStatusVO.setLast6monthAvg(
//						nearCreditStatusLast6monthAvgs[i].equals("-9999") ? "" : nearCreditStatusLast6monthAvgs[i]);
//				pbocNearcreditStatusVO.setMaxUsedAmount(
//						nearCreditStatusMaxUsedAmounts[i].equals("-9999") ? "" : nearCreditStatusMaxUsedAmounts[i]);
//				pbocNearcreditStatusVO
//						.setBillDate(nearCreditStatusBillDates[i].equals("-9999") ? "" : nearCreditStatusBillDates[i]);
//				pbocNearcreditStatusVO.setRepayedAtMonth(
//						nearCreditStatusRepayedAtMonths[i].equals("-9999") ? "" : nearCreditStatusRepayedAtMonths[i]);
//				pbocNearcreditStatusVO.setLastRepayDate(
//						nearCreditStatusLastRepayDates[i].equals("-9999") ? "" : nearCreditStatusLastRepayDates[i]);
//				pbocNearcreditStatusVO.setOverdue180dAmount(
//						nearCreditStatusOverdue180dAmounts[i].equals("-9999") ? "" : nearCreditStatusOverdue180dAmounts[i]);
//				pbocNearcreditStatusService.insertPbocNearcreditStatus(pbocNearcreditStatusVO);
//			}
//			// 3.21插入对外担保明细信息表
//			PbocLoadGuaranteelDetailVO pbocLoadGuaranteelDetailVO = new PbocLoadGuaranteelDetailVO();
//			String[] loadGuaranteelDetailSns = loadGuaranteelDetailSn.split("|+|");
//			String[] loadGuaranteelDetailOrganizations = loadGuaranteelDetailOrganization.split("|+|");
//			String[] loadGuaranteelDetailContractAmounts = loadGuaranteelDetailContractAmount.split("|+|");
//			String[] loadGuaranteelDetailIssueDates = loadGuaranteelDetailIssueDate.split("|+|");
//			String[] loadGuaranteelDetailEndDates = loadGuaranteelDetailEndDate.split("|+|");
//			String[] loadGuaranteelDetailBondsAmounts = loadGuaranteelDetailBondsAmount.split("|+|");
//			String[] loadGuaranteelDetailBasicAmounts = loadGuaranteelDetailBasicAmount.split("|+|");
//			String[] loadGuaranteelDetailFiveStyles = loadGuaranteelDetailFiveStyle.split("|+|");
//			String[] loadGuaranteelDetailNeedRepayDates = loadGuaranteelDetailNeedRepayDate.split("|+|");
//			for (int i = 0; i < loadGuaranteelDetailSns.length; i++) {
//				pbocLoadGuaranteelDetailVO.setPId(loadGuaranteelDetailPId);
//				pbocLoadGuaranteelDetailVO.setFId(loadGuaranteelDetailFId.equals("-9999") ? "" : loadGuaranteelDetailFId);
//				pbocLoadGuaranteelDetailVO
//						.setSn(loadGuaranteelDetailSns[i].equals("-9999") ? "" : loadGuaranteelDetailSns[i]);
//				pbocLoadGuaranteelDetailVO.setOrganization(
//						loadGuaranteelDetailOrganizations[i].equals("-9999") ? "" : loadGuaranteelDetailOrganizations[i]);
//				pbocLoadGuaranteelDetailVO.setContractAmount(loadGuaranteelDetailContractAmounts[i].equals("-9999") ? ""
//						: loadGuaranteelDetailContractAmounts[i]);
//				pbocLoadGuaranteelDetailVO.setIssueDate(
//						loadGuaranteelDetailIssueDates[i].equals("-9999") ? "" : loadGuaranteelDetailIssueDates[i]);
//				pbocLoadGuaranteelDetailVO
//						.setEndDate(loadGuaranteelDetailEndDates[i].equals("-9999") ? "" : loadGuaranteelDetailEndDates[i]);
//				pbocLoadGuaranteelDetailVO.setBondsAmount(
//						loadGuaranteelDetailBondsAmounts[i].equals("-9999") ? "" : loadGuaranteelDetailBondsAmounts[i]);
//				pbocLoadGuaranteelDetailVO.setBasicAmount(
//						loadGuaranteelDetailBasicAmounts[i].equals("-9999") ? "" : loadGuaranteelDetailBasicAmounts[i]);
//				pbocLoadGuaranteelDetailVO.setFiveStyle(
//						loadGuaranteelDetailFiveStyles[i].equals("-9999") ? "" : loadGuaranteelDetailFiveStyles[i]);
//				pbocLoadGuaranteelDetailVO.setNeedRepayDate(
//						loadGuaranteelDetailNeedRepayDates[i].equals("-9999") ? "" : loadGuaranteelDetailNeedRepayDates[i]);
//				pbocLoadGuaranteelDetailService.insertPbocLoadGuaranteelDetail(pbocLoadGuaranteelDetailVO);
//			}
//			// 3.22插入对外信用卡担保信息表
//			PbocCreditGuaranteelDetailVO pbocCreditGuaranteelDetailVO = new PbocCreditGuaranteelDetailVO();
//			String[] creditGuaranteelDetailSns = creditGuaranteelDetailSn.split("|+|");
//			String[] creditGuaranteelDetailOrganizations = creditGuaranteelDetailOrganization.split("|+|");
//			String[] creditGuaranteelDetailContractAmounts = creditGuaranteelDetailContractAmount.split("|+|");
//			String[] creditGuaranteelDetailIssueDates = creditGuaranteelDetailIssueDate.split("|+|");
//			String[] creditGuaranteelDetailBondsAmounts = creditGuaranteelDetailBondsAmount.split("|+|");
//			String[] creditGuaranteelDetailUsedAmounts = creditGuaranteelDetailUsedAmount.split("|+|");
//			String[] creditGuaranteelDetailBillDates = creditGuaranteelDetailBillDate.split("|+|");
//			for (int i = 0; i < creditGuaranteelDetailSns.length; i++) {
//				pbocCreditGuaranteelDetailVO.setPId(creditGuaranteelDetailPId);
//				pbocCreditGuaranteelDetailVO
//						.setFId(creditGuaranteelDetailFId.equals("-9999") ? "" : creditGuaranteelDetailFId);
//				pbocCreditGuaranteelDetailVO
//						.setSn(creditGuaranteelDetailSns[i].equals("-9999") ? "" : creditGuaranteelDetailSns[i]);
//				pbocCreditGuaranteelDetailVO.setOrganization(creditGuaranteelDetailOrganizations[i].equals("-9999") ? ""
//						: creditGuaranteelDetailOrganizations[i]);
//				pbocCreditGuaranteelDetailVO.setContractAmount(creditGuaranteelDetailContractAmounts[i].equals("-9999") ? ""
//						: creditGuaranteelDetailContractAmounts[i]);
//				pbocCreditGuaranteelDetailVO.setIssueDate(
//						creditGuaranteelDetailIssueDates[i].equals("-9999") ? "" : creditGuaranteelDetailIssueDates[i]);
//				pbocCreditGuaranteelDetailVO.setBondsAmount(
//						creditGuaranteelDetailBondsAmounts[i].equals("-9999") ? "" : creditGuaranteelDetailBondsAmounts[i]);
//				pbocCreditGuaranteelDetailVO.setUsedAmount(
//						creditGuaranteelDetailUsedAmounts[i].equals("-9999") ? "" : creditGuaranteelDetailUsedAmounts[i]);
//				pbocCreditGuaranteelDetailVO.setBillDate(
//						creditGuaranteelDetailBillDates[i].equals("-9999") ? "" : creditGuaranteelDetailBillDates[i]);
//				pbocCreditGuaranteelDetailService.insertPbocCreditGuaranteelDetail(pbocCreditGuaranteelDetailVO);
//			}
//			// 3.23插入欠税记录表
//			PbocOwingTaxesVO pbocOwingTaxesVO = new PbocOwingTaxesVO();
//			String[] owingTaxesSns = owingTaxesSn.split("|+|");
//			String[] owingTaxesOrganizations = owingTaxesOrganization.split("|+|");
//			String[] owingTaxesOwingTaxesSums = owingTaxesOwingTaxesSum.split("|+|");
//			String[] owingTaxesStatisticsDates = owingTaxesStatisticsDate.split("|+|");
//			for (int i = 0; i < owingTaxesSns.length; i++) {
//				pbocOwingTaxesVO.setPId(owingTaxesPId);
//				pbocOwingTaxesVO.setFId(owingTaxesFId.equals("-9999") ? "" : owingTaxesFId);
//				pbocOwingTaxesVO.setSn(owingTaxesSns[i].equals("-9999") ? "" : owingTaxesSns[i]);
//				pbocOwingTaxesVO
//						.setOrganization(owingTaxesOrganizations[i].equals("-9999") ? "" : owingTaxesOrganizations[i]);
//				pbocOwingTaxesVO
//						.setOwingTaxesSum(owingTaxesOwingTaxesSums[i].equals("-9999") ? "" : owingTaxesOwingTaxesSums[i]);
//				pbocOwingTaxesVO
//						.setStatisticsDate(owingTaxesStatisticsDates[i].equals("-9999") ? "" : owingTaxesStatisticsDates[i]);
//				pbocOwingTaxesService.insertPbocOwingTaxes(pbocOwingTaxesVO);
//			}
//			// 3.24插入欠税记录表
//			PbocCivilJudgementVO pbocCivilJudgementVO = new PbocCivilJudgementVO();
//			String[] civilJudgementSns = civilJudgementSn.split("|+|");
//			String[] civilJudgementCourts = civilJudgementCourt.split("|+|");
//			String[] civilJudgementReasons = civilJudgementReason.split("|+|");
//			String[] civilJudgementRegesterDates = civilJudgementRegesterDate.split("|+|");
//			String[] civilJudgementEndWays = civilJudgementEndWay.split("|+|");
//			String[] civilJudgementResults = civilJudgementResult.split("|+|");
//			String[] civilJudgementResultBegDates = civilJudgementResultBegDate.split("|+|");
//			String[] civilJudgementCaseObjects = civilJudgementCaseObject.split("|+|");
//			String[] civilJudgementCaseObjectAmounts = civilJudgementCaseObjectAmount.split("|+|");
//			for (int i = 0; i < civilJudgementSns.length; i++) {
//				pbocCivilJudgementVO.setPId(civilJudgementPId);
//				pbocCivilJudgementVO.setFId(civilJudgementFId.equals("-9999") ? "" : civilJudgementFId);
//				pbocCivilJudgementVO.setSn(civilJudgementSns[i].equals("-9999") ? "" : civilJudgementSns[i]);
//				pbocCivilJudgementVO.setCourt(civilJudgementCourts[i].equals("-9999") ? "" : civilJudgementCourts[i]);
//				pbocCivilJudgementVO.setReason(civilJudgementReasons[i].equals("-9999") ? "" : civilJudgementReasons[i]);
//				pbocCivilJudgementVO.setRegesterDate(
//						civilJudgementRegesterDates[i].equals("-9999") ? "" : civilJudgementRegesterDates[i]);
//				pbocCivilJudgementVO.setEndWay(civilJudgementEndWays[i].equals("-9999") ? "" : civilJudgementEndWays[i]);
//				pbocCivilJudgementVO.setResult(civilJudgementResults[i].equals("-9999") ? "" : civilJudgementResults[i]);
//				pbocCivilJudgementVO.setResultBegDate(
//						civilJudgementResultBegDates[i].equals("-9999") ? "" : civilJudgementResultBegDates[i]);
//				pbocCivilJudgementVO
//						.setCaseObject(civilJudgementCaseObjects[i].equals("-9999") ? "" : civilJudgementCaseObjects[i]);
//				pbocCivilJudgementVO.setCaseObjectAmount(
//						civilJudgementCaseObjectAmounts[i].equals("-9999") ? "" : civilJudgementCaseObjectAmounts[i]);
//				pbocCivilJudgementService.insertPbocCivilJudgement(pbocCivilJudgementVO);
//			}
//			// 3.25插入法院强制执行记录表
//			PbocForcecarryVO pbocForcecarryVO = new PbocForcecarryVO();
//			String[] forcecarrySns = forcecarrySn.split("|+|");
//			String[] forcecarryCourts = forcecarryCourt.split("|+|");
//			String[] forcecarryReasons = forcecarryReason.split("|+|");
//			String[] forcecarryRegesterDates = forcecarryRegesterDate.split("|+|");
//			String[] forcecarryEndWays = forcecarryEndWay.split("|+|");
//			String[] forcecarryCaseStatuses = forcecarryCaseStatus.split("|+|");
//			String[] forcecarryEndDates = forcecarryEndDate.split("|+|");
//			String[] forcecarryCaseObjects = forcecarryCaseObject.split("|+|");
//			String[] forcecarryCaseObjectAmounts = forcecarryCaseObjectAmount.split("|+|");
//			String[] forcecarryHadObjects = forcecarryHadObject.split("|+|");
//			String[] forcecarryHadObjectAmounts = forcecarryHadObjectAmount.split("|+|");
//			for (int i = 0; i < forcecarrySns.length; i++) {
//				pbocForcecarryVO.setPId(forcecarryPId);
//				pbocForcecarryVO.setFId(forcecarryFId.equals("-9999") ? "" : forcecarryFId);
//				pbocForcecarryVO.setSn(forcecarrySns[i].equals("-9999") ? "" : forcecarrySns[i]);
//				pbocForcecarryVO.setCourt(forcecarryCourts[i].equals("-9999") ? "" : forcecarryCourts[i]);
//				pbocForcecarryVO.setReason(forcecarryReasons[i].equals("-9999") ? "" : forcecarryReasons[i]);
//				pbocForcecarryVO
//						.setRegesterDate(forcecarryRegesterDates[i].equals("-9999") ? "" : forcecarryRegesterDates[i]);
//				pbocForcecarryVO.setEndWay(forcecarryEndWays[i].equals("-9999") ? "" : forcecarryEndWays[i]);
//				pbocForcecarryVO.setCaseStatus(forcecarryCaseStatuses[i].equals("-9999") ? "" : forcecarryCaseStatuses[i]);
//				pbocForcecarryVO.setEndDate(forcecarryEndDates[i].equals("-9999") ? "" : forcecarryEndDates[i]);
//				pbocForcecarryVO.setCaseObject(forcecarryCaseObjects[i].equals("-9999") ? "" : forcecarryCaseObjects[i]);
//				pbocForcecarryVO.setCaseObjectAmount(
//						forcecarryCaseObjectAmounts[i].equals("-9999") ? "" : forcecarryCaseObjectAmounts[i]);
//				pbocForcecarryVO.setHadObject(forcecarryHadObjects[i].equals("-9999") ? "" : forcecarryHadObjects[i]);
//				pbocForcecarryVO.setHadObjectAmount(
//						forcecarryHadObjectAmounts[i].equals("-9999") ? "" : forcecarryHadObjectAmounts[i]);
//				pbocForcecarryService.insertPbocForcecarry(pbocForcecarryVO);
//			}
//			// 3.26插入行政处罚记录表
//			PbocPunishVO pbocPunishVO = new PbocPunishVO();
//			String[] punishSns = punishSn.split("|+|");
//			String[] punishOrganizations = punishOrganization.split("|+|");
//			String[] punishPunishContents = punishPunishContent.split("|+|");
//			String[] punishPunishAmounts = punishPunishAmount.split("|+|");
//			String[] punishEffectiveDates = punishEffectiveDate.split("|+|");
//			String[] punishEndDates = punishEndDate.split("|+|");
//			String[] punishReconsiderResults = punishReconsiderResult.split("|+|");
//			for (int i = 0; i < punishSns.length; i++) {
//				pbocPunishVO.setPId(punishPId);
//				pbocPunishVO.setFId(punishFId.equals("-9999") ? "" : punishFId);
//				pbocPunishVO.setSn(punishSns[i].equals("-9999") ? "" : punishSns[i]);
//				pbocPunishVO.setOrganization(punishOrganizations[i].equals("-9999") ? "" : punishOrganizations[i]);
//				pbocPunishVO.setPunishContent(punishPunishContents[i].equals("-9999") ? "" : punishPunishContents[i]);
//				pbocPunishVO.setPunishAmount(punishPunishAmounts[i].equals("-9999") ? "" : punishPunishAmounts[i]);
//				pbocPunishVO.setEffectiveDate(punishEffectiveDates[i].equals("-9999") ? "" : punishEffectiveDates[i]);
//				pbocPunishVO.setEndDate(punishEndDates[i].equals("-9999") ? "" : punishEndDates[i]);
//				pbocPunishVO
//						.setReconsiderResult(punishReconsiderResults[i].equals("-9999") ? "" : punishReconsiderResults[i]);
//				pbocPunishService.insertPbocPunish(pbocPunishVO);
//			}
//			// 3.27插入住房公积金参缴记录表
//			PbocHouseprovidentVO pbocHouseprovidentVO = new PbocHouseprovidentVO();
//			String[] houseprovidentSns = houseprovidentSn.split("|+|");
//			String[] houseprovidentLocations = houseprovidentLocation.split("|+|");
//			String[] houseprovidentPayDates = houseprovidentPayDate.split("|+|");
//			String[] houseprovidentFirstPayMonths = houseprovidentFirstPayMonth.split("|+|");
//			String[] houseprovidentEndPayDates = houseprovidentEndPayDate.split("|+|");
//			String[] houseprovidentPayStatuses = houseprovidentPayStatus.split("|+|");
//			String[] houseprovidentPayPerMonths = houseprovidentPayPerMonth.split("|+|");
//			String[] houseprovidentSingleRates = houseprovidentSingleRate.split("|+|");
//			String[] houseprovidentCompanyRates = houseprovidentCompanyRate.split("|+|");
//			String[] houseprovidentCompanys = houseprovidentCompany.split("|+|");
//			String[] houseprovidentNewsUpdateDates = houseprovidentNewsUpdateDate.split("|+|");
//			for (int i = 0; i < houseprovidentSns.length; i++) {
//				pbocHouseprovidentVO.setPId(houseprovidentPId);
//				pbocHouseprovidentVO.setFId(houseprovidentFId.equals("-9999") ? "" : houseprovidentFId);
//				pbocHouseprovidentVO.setSn(houseprovidentSns[i].equals("-9999") ? "" : houseprovidentSns[i]);
//				pbocHouseprovidentVO
//						.setLocation(houseprovidentLocations[i].equals("-9999") ? "" : houseprovidentLocations[i]);
//				pbocHouseprovidentVO.setPayDate(houseprovidentPayDates[i].equals("-9999") ? "" : houseprovidentPayDates[i]);
//				pbocHouseprovidentVO.setFirstPayMonth(
//						houseprovidentFirstPayMonths[i].equals("-9999") ? "" : houseprovidentFirstPayMonths[i]);
//				pbocHouseprovidentVO
//						.setEndPayDate(houseprovidentEndPayDates[i].equals("-9999") ? "" : houseprovidentEndPayDates[i]);
//				pbocHouseprovidentVO
//						.setPayStatus(houseprovidentPayStatuses[i].equals("-9999") ? "" : houseprovidentPayStatuses[i]);
//				pbocHouseprovidentVO
//						.setPayPerMonth(houseprovidentPayPerMonths[i].equals("-9999") ? "" : houseprovidentPayPerMonths[i]);
//				pbocHouseprovidentVO
//						.setSingleRate(houseprovidentSingleRates[i].equals("-9999") ? "" : houseprovidentSingleRates[i]);
//				pbocHouseprovidentVO
//						.setCompanyRate(houseprovidentCompanyRates[i].equals("-9999") ? "" : houseprovidentCompanyRates[i]);
//				pbocHouseprovidentVO.setCompany(houseprovidentCompanys[i].equals("-9999") ? "" : houseprovidentCompanys[i]);
//				pbocHouseprovidentVO.setNewsUpdateDate(
//						houseprovidentNewsUpdateDates[i].equals("-9999") ? "" : houseprovidentNewsUpdateDates[i]);
//				pbocHouseprovidentService.insertPbocHouseprovident(pbocHouseprovidentVO);
//			}
//			// 3.28插入养老保险金缴存记录表
//			PbocEndowmentInsurancecacheVO pbocEndowmentInsurancecacheVO = new PbocEndowmentInsurancecacheVO();
//			String[] endowmentInsurancegrantSns = endowmentInsurancegrantSn.split("|+|");
//			String[] endowmentInsurancegrantLocations = endowmentInsurancegrantLocation.split("|+|");
//			String[] endowmentInsurancegrantPayDates = endowmentInsurancegrantPayDate.split("|+|");
//			String[] endowmentInsurancegrantPayMonthSums = endowmentInsurancegrantPayMonthSum.split("|+|");
//			String[] endowmentInsurancegrantBegWorkMonths = endowmentInsurancegrantBegWorkMonth.split("|+|");
//			String[] endowmentInsurancegrantPayStatuses = endowmentInsurancegrantPayStatus.split("|+|");
//			String[] endowmentInsurancegrantSingleBasicAmounts = endowmentInsurancegrantSingleBasicAmount.split("|+|");
//			String[] endowmentInsurancegrantPayAmounts = endowmentInsurancegrantPayAmount.split("|+|");
//			String[] endowmentInsurancegrantNewsUpdateDates = endowmentInsurancegrantNewsUpdateDate.split("|+|");
//			String[] endowmentInsurancegrantCompanys = endowmentInsurancegrantCompany.split("|+|");
//			String[] endowmentInsurancegrantTerminedReasons = endowmentInsurancegrantTerminedReason.split("|+|");
//			for (int i = 0; i < endowmentInsurancegrantSns.length; i++) {
//				pbocEndowmentInsurancecacheVO.setPId(endowmentInsurancegrantPId);
//				pbocEndowmentInsurancecacheVO
//						.setFId(endowmentInsurancegrantFId.equals("-9999") ? "" : endowmentInsurancegrantFId);
//				pbocEndowmentInsurancecacheVO
//						.setSn(endowmentInsurancegrantSns[i].equals("-9999") ? "" : endowmentInsurancegrantSns[i]);
//				pbocEndowmentInsurancecacheVO.setLocation(
//						endowmentInsurancegrantLocations[i].equals("-9999") ? "" : endowmentInsurancegrantLocations[i]);
//				pbocEndowmentInsurancecacheVO.setPayDate(
//						endowmentInsurancegrantPayDates[i].equals("-9999") ? "" : endowmentInsurancegrantPayDates[i]);
//				pbocEndowmentInsurancecacheVO.setPayMonthSum(endowmentInsurancegrantPayMonthSums[i].equals("-9999") ? ""
//						: endowmentInsurancegrantPayMonthSums[i]);
//				pbocEndowmentInsurancecacheVO.setBegWorkMonth(endowmentInsurancegrantBegWorkMonths[i].equals("-9999") ? ""
//						: endowmentInsurancegrantBegWorkMonths[i]);
//				pbocEndowmentInsurancecacheVO.setPayStatus(
//						endowmentInsurancegrantPayStatuses[i].equals("-9999") ? "" : endowmentInsurancegrantPayStatuses[i]);
//				pbocEndowmentInsurancecacheVO
//						.setSingleBasicAmount(endowmentInsurancegrantSingleBasicAmounts[i].equals("-9999") ? ""
//								: endowmentInsurancegrantSingleBasicAmounts[i]);
//				pbocEndowmentInsurancecacheVO.setPayAmount(
//						endowmentInsurancegrantPayAmounts[i].equals("-9999") ? "" : endowmentInsurancegrantPayAmounts[i]);
//				pbocEndowmentInsurancecacheVO
//						.setNewsUpdateDate(endowmentInsurancegrantNewsUpdateDates[i].equals("-9999") ? ""
//								: endowmentInsurancegrantNewsUpdateDates[i]);
//				pbocEndowmentInsurancecacheVO.setCompany(
//						endowmentInsurancegrantCompanys[i].equals("-9999") ? "" : endowmentInsurancegrantCompanys[i]);
//				pbocEndowmentInsurancecacheVO
//						.setTerminedReason(endowmentInsurancegrantTerminedReasons[i].equals("-9999") ? ""
//								: endowmentInsurancegrantTerminedReasons[i]);
//				pbocEndowmentInsurancecacheService.insertPbocEndowmentInsurancecache(pbocEndowmentInsurancecacheVO);
//			}
//			// 3.29插入低保救助记录表
//			PbocLowIncomeVO pbocLowIncomeVO = new PbocLowIncomeVO();
//			String[] lowIncomeSns = lowIncomeSn.split("|+|");
//			String[] lowIncomePersonStyles = lowIncomePersonStyle.split("|+|");
//			String[] lowIncomeLocations = lowIncomeLocation.split("|+|");
//			String[] lowIncomeCompanys = lowIncomeCompany.split("|+|");
//			String[] lowIncomeFamilyMonthIncomes = lowIncomeFamilyMonthIncome.split("|+|");
//			String[] lowIncomeApplyDates = lowIncomeApplyDate.split("|+|");
//			String[] lowIncomeApproveDates = lowIncomeApproveDate.split("|+|");
//			String[] lowIncomeNewsUpdateDates = lowIncomeNewsUpdateDate.split("|+|");
//			for (int i = 0; i < lowIncomeSns.length; i++) {
//				pbocLowIncomeVO.setPId(lowIncomePId);
//				pbocLowIncomeVO.setFId(lowIncomeFId.equals("-9999") ? "" : lowIncomeFId);
//				pbocLowIncomeVO.setSn(lowIncomeSns[i].equals("-9999") ? "" : lowIncomeSns[i]);
//				pbocLowIncomeVO.setPersonStyle(lowIncomePersonStyles[i].equals("-9999") ? "" : lowIncomePersonStyles[i]);
//				pbocLowIncomeVO.setLocation(lowIncomeLocations[i].equals("-9999") ? "" : lowIncomeLocations[i]);
//				pbocLowIncomeVO.setCompany(lowIncomeCompanys[i].equals("-9999") ? "" : lowIncomeCompanys[i]);
//				pbocLowIncomeVO.setFamilyMonthIncome(
//						lowIncomeFamilyMonthIncomes[i].equals("-9999") ? "" : lowIncomeFamilyMonthIncomes[i]);
//				pbocLowIncomeVO.setApplyDate(lowIncomeApplyDates[i].equals("-9999") ? "" : lowIncomeApplyDates[i]);
//				pbocLowIncomeVO.setApproveDate(lowIncomeApproveDates[i].equals("-9999") ? "" : lowIncomeApproveDates[i]);
//				pbocLowIncomeVO
//						.setNewsUpdateDate(lowIncomeNewsUpdateDates[i].equals("-9999") ? "" : lowIncomeNewsUpdateDates[i]);
//				pbocLowIncomeService.insertPbocLowIncome(pbocLowIncomeVO);
//			}
//			// 3.30插入执业资格记录表
//			PbocPracticReqVO pbocPracticReqVO = new PbocPracticReqVO();
//			String[] practicReqSns = practicReqSn.split("|+|");
//			String[] practicReqReqNames = practicReqReqName.split("|+|");
//			String[] practicReqReqLevels = practicReqReqLevel.split("|+|");
//			String[] practicReqGetReqDates = practicReqGetReqDate.split("|+|");
//			String[] practicReqEndReqDates = practicReqEndReqDate.split("|+|");
//			String[] practicReqDropReqDates = practicReqDropReqDate.split("|+|");
//			String[] practicReqOrganizations = practicReqOrganization.split("|+|");
//			String[] practicReqLocations = practicReqLocation.split("|+|");
//			for (int i = 0; i < practicReqSns.length; i++) {
//				pbocPracticReqVO.setPId(practicReqPId);
//				pbocPracticReqVO.setFId(practicReqFId.equals("-9999") ? "" : practicReqFId);
//				pbocPracticReqVO.setSn(practicReqSns[i].equals("-9999") ? "" : practicReqSns[i]);
//				pbocPracticReqVO.setReqName(practicReqReqNames[i].equals("-9999") ? "" : practicReqReqNames[i]);
//				pbocPracticReqVO.setReqLevel(practicReqReqLevels[i].equals("-9999") ? "" : practicReqReqLevels[i]);
//				pbocPracticReqVO.setGetReqDate(practicReqGetReqDates[i].equals("-9999") ? "" : practicReqGetReqDates[i]);
//				pbocPracticReqVO.setEndReqDate(practicReqEndReqDates[i].equals("-9999") ? "" : practicReqEndReqDates[i]);
//				pbocPracticReqVO.setDropReqDate(practicReqDropReqDates[i].equals("-9999") ? "" : practicReqDropReqDates[i]);
//				pbocPracticReqVO
//						.setOrganization(practicReqOrganizations[i].equals("-9999") ? "" : practicReqOrganizations[i]);
//				pbocPracticReqVO.setLocation(practicReqLocations[i].equals("-9999") ? "" : practicReqLocations[i]);
//				pbocPracticReqService.insertPbocPracticReq(pbocPracticReqVO);
//			}
//			// 3.31插入执业资格记录表
//			PbocRewardVO pbocRewardVO = new PbocRewardVO();
//			String[] rewardSns = rewardSn.split("|+|");
//			String[] rewardOrganizations = rewardOrganization.split("|+|");
//			String[] rewardContents = rewardContent.split("|+|");
//			String[] rewardEffectiveDates = rewardEffectiveDate.split("|+|");
//			String[] rewardEndDates = rewardEndDate.split("|+|");
//			for (int i = 0; i < rewardSns.length; i++) {
//				pbocRewardVO.setPId(rewardPId);
//				pbocRewardVO.setFId(rewardFId.equals("-9999") ? "" : rewardFId);
//				pbocRewardVO.setSn(rewardSns[i].equals("-9999") ? "" : rewardSns[i]);
//				pbocRewardVO.setOrganization(rewardOrganizations[i].equals("-9999") ? "" : rewardOrganizations[i]);
//				pbocRewardVO.setContent(rewardContents[i].equals("-9999") ? "" : rewardContents[i]);
//				pbocRewardVO.setEffectiveDate(rewardEffectiveDates[i].equals("-9999") ? "" : rewardEffectiveDates[i]);
//				pbocRewardVO.setEndDate(rewardEndDates[i].equals("-9999") ? "" : rewardEndDates[i]);
//				pbocRewardService.insertPbocReward(pbocRewardVO);
//			}
//			// 3.32插入车辆交易和抵押记录表
//			PbocCarVO pbocCarVO = new PbocCarVO();
//			String[] carSns = carSn.split("|+|");
//			String[] carCardNumbers = carCardNumber.split("|+|");
//			String[] carEngineNumbers = carEngineNumber.split("|+|");
//			String[] carBrands = carBrand.split("|+|");
//			String[] carCardTypes = carCardType.split("|+|");
//			String[] carUseAttrs = carUseAttr.split("|+|");
//			String[] carCardStatuses = carCardStatus.split("|+|");
//			String[] carPledgeStatuses = carPledgeStatus.split("|+|");
//			String[] carNewsUpdateDates = carNewsUpdateDate.split("|+|");
//			for (int i = 0; i < carSns.length; i++) {
//				pbocCarVO.setPId(carPId);
//				pbocCarVO.setFId(carFId.equals("-9999") ? "" : carFId);
//				pbocCarVO.setSn(carSns[i].equals("-9999") ? "" : carSns[i]);
//				pbocCarVO.setCardNumber(carCardNumbers[i].equals("-9999") ? "" : carCardNumbers[i]);
//				pbocCarVO.setEngineNumber(carEngineNumbers[i].equals("-9999") ? "" : carEngineNumbers[i]);
//				pbocCarVO.setBrand(carBrands[i].equals("-9999") ? "" : carBrands[i]);
//				pbocCarVO.setCardType(carCardTypes[i].equals("-9999") ? "" : carCardTypes[i]);
//				pbocCarVO.setUseAttr(carUseAttrs[i].equals("-9999") ? "" : carUseAttrs[i]);
//				pbocCarVO.setCardStatus(carCardStatuses[i].equals("-9999") ? "" : carCardStatuses[i]);
//				pbocCarVO.setPledgeStatus(carPledgeStatuses[i].equals("-9999") ? "" : carPledgeStatuses[i]);
//				pbocCarVO.setNewsUpdateDate(carNewsUpdateDates[i].equals("-9999") ? "" : carNewsUpdateDates[i]);
//				pbocCarService.insertPbocCar(pbocCarVO);
//			}
//			// 3.33插入电信缴费记录表
//			PbocTelecomVO pbocTelecomVO = new PbocTelecomVO();
//			String[] telecomSns = telecomSn.split("|+|");
//			String[] telecomTelecomCompanys = telecomTelecomCompany.split("|+|");
//			String[] telecomBusinessTypes = telecomBusinessType.split("|+|");
//			String[] telecomBusinessOpenDates = telecomBusinessOpenDate.split("|+|");
//			String[] telecomPaymenyStatuses = telecomPaymenyStatus.split("|+|");
//			String[] telecomPostageDues = telecomPostageDue.split("|+|");
//			String[] telecomPostageMonthses = telecomPostageMonths.split("|+|");
//			String[] telecomAccountingDates = telecomAccountingDate.split("|+|");
//			String[] telecomMonth24statuses = telecomMonth24status.split("|+|");
//			for (int i = 0; i < telecomSns.length; i++) {
//				pbocTelecomVO.setPId(telecomPId);
//				pbocTelecomVO.setFId(telecomFId.equals("-9999") ? "" : telecomFId);
//				pbocTelecomVO.setSn(telecomSns[i].equals("-9999") ? "" : telecomSns[i]);
//				pbocTelecomVO.setTelecomCompany(telecomTelecomCompanys[i].equals("-9999") ? "" : telecomTelecomCompanys[i]);
//				pbocTelecomVO.setBusinessType(telecomBusinessTypes[i].equals("-9999") ? "" : telecomBusinessTypes[i]);
//				pbocTelecomVO
//						.setBusinessOpenDate(telecomBusinessOpenDates[i].equals("-9999") ? "" : telecomBusinessOpenDates[i]);
//				pbocTelecomVO.setPaymenyStatus(telecomPaymenyStatuses[i].equals("-9999") ? "" : telecomPaymenyStatuses[i]);
//				pbocTelecomVO.setPostageDue(telecomPostageDues[i].equals("-9999") ? "" : telecomPostageDues[i]);
//				pbocTelecomVO.setPostageMonths(telecomPostageMonthses[i].equals("-9999") ? "" : telecomPostageMonthses[i]);
//				pbocTelecomVO.setAccountingDate(telecomAccountingDates[i].equals("-9999") ? "" : telecomAccountingDates[i]);
//				pbocTelecomVO.setMonth24status(telecomMonth24statuses[i].equals("-9999") ? "" : telecomMonth24statuses[i]);
//				pbocTelecomService.insertPbocTelecom(pbocTelecomVO);
//			}
//			// 3.34插入本人声明表
//			PbocDescriptionVO pbocDescriptionVO = new PbocDescriptionVO();
//			String[] descriptionSns = descriptionSn.split("|+|");
//			String[] descriptionDescriptionContents = descriptionDescriptionContent.split("|+|");
//			String[] descriptionUpdateDates = descriptionUpdateDate.split("|+|");
//			for (int i = 0; i < descriptionSns.length; i++) {
//				pbocDescriptionVO.setPId(descriptionPId);
//				pbocDescriptionVO.setFId(descriptionFId.equals("-9999") ? "" : descriptionFId);
//				pbocDescriptionVO.setSn(descriptionSns[i].equals("-9999") ? "" : descriptionSns[i]);
//				pbocDescriptionVO.setDescriptionContent(
//						descriptionDescriptionContents[i].equals("-9999") ? "" : descriptionDescriptionContents[i]);
//				pbocDescriptionVO.setUpdateDate(descriptionUpdateDates[i].equals("-9999") ? "" : descriptionUpdateDates[i]);
//				pbocDescriptionVO.setTableStyle(descriptionTableStyle.equals("-9999") ? "" : descriptionTableStyle);
//				pbocDescriptionService.insertPbocDescription(pbocDescriptionVO);
//			}
//			// 3.35插入异议标注表
//			String[] dissentSns = dissentSn.split("|+|");
//			String[] dissentDescriptionContents = dissentDescriptionContent.split("|+|");
//			String[] dissentUpdateDates = dissentUpdateDate.split("|+|");
//			for (int i = 0; i < dissentSns.length; i++) {
//				pbocDescriptionVO.setPId(dissentPId);
//				pbocDescriptionVO.setFId(dissentFId.equals("-9999") ? "" : dissentFId);
//				pbocDescriptionVO.setSn(dissentSns[i].equals("-9999") ? "" : dissentSns[i]);
//				pbocDescriptionVO.setDescriptionContent(
//						dissentDescriptionContents[i].equals("-9999") ? "" : dissentDescriptionContents[i]);
//				pbocDescriptionVO.setUpdateDate(dissentUpdateDates[i].equals("-9999") ? "" : dissentUpdateDates[i]);
//				pbocDescriptionVO.setTableStyle(dissentTableStyle.equals("-9999") ? "" : dissentTableStyle);
//				pbocDescriptionService.insertPbocDescription(pbocDescriptionVO);
//			}
//			// 3.36插入查询记录汇总信息表
//			PbocCreditquerySummaryVO pbocCreditquerySummaryVO = new PbocCreditquerySummaryVO();
//			pbocCreditquerySummaryVO.setPId(creditquerySummaryPId);
//			pbocCreditquerySummaryVO.setFId(creditquerySummaryFId.equals("-9999") ? "" : creditquerySummaryFId);
//			pbocCreditquerySummaryVO.setLoadQueryOrganizations(creditquerySummaryLoadQueryOrganizations.equals("-9999") ? ""
//					: creditquerySummaryLoadQueryOrganizations);
//			pbocCreditquerySummaryVO
//					.setCreditQueryOrganizations(creditquerySummaryCreditQueryOrganizations.equals("-9999") ? ""
//							: creditquerySummaryCreditQueryOrganizations);
//			pbocCreditquerySummaryVO.setLoadQueryTimes(
//					creditquerySummaryLoadQueryTimes.equals("-9999") ? "" : creditquerySummaryLoadQueryTimes);
//			pbocCreditquerySummaryVO.setCreditQueryTimes(
//					creditquerySummaryCreditQueryTimes.equals("-9999") ? "" : creditquerySummaryCreditQueryTimes);
//			pbocCreditquerySummaryVO.setPersonalQueryTimes(
//					creditquerySummaryPersonalQueryTimes.equals("-9999") ? "" : creditquerySummaryPersonalQueryTimes);
//			pbocCreditquerySummaryVO.setAffterLoadManage(
//					creditquerySummaryAffterLoadManage.equals("-9999") ? "" : creditquerySummaryAffterLoadManage);
//			pbocCreditquerySummaryVO
//					.setBondsApprove(creditquerySummaryBondsApprove.equals("-9999") ? "" : creditquerySummaryBondsApprove);
//			pbocCreditquerySummaryVO.setSpecialMerchant(
//					creditquerySummarySpecialMerchant.equals("-9999") ? "" : creditquerySummarySpecialMerchant);
//			pbocCreditquerySummaryService.insertPbocCreditquerySummary(pbocCreditquerySummaryVO);
//			// 3.37插入信贷审批查询记录明细表
//			PbocCreditqueryDetailVO PbocCreditqueryDetailVO = new PbocCreditqueryDetailVO();
//			String[] creditqueryDetailSns = creditqueryDetailSn.split("|+|");
//			String[] creditqueryDetailQueryDates = creditqueryDetailQueryDate.split("|+|");
//			String[] creditqueryDetailQueryUsers = creditqueryDetailQueryUser.split("|+|");
//			String[] creditqueryDetailQueryReasons = creditqueryDetailQueryReason.split("|+|");
//			for (int i = 0; i < creditqueryDetailSns.length; i++) {
//				PbocCreditqueryDetailVO.setPId(creditqueryDetailPId);
//				PbocCreditqueryDetailVO
//						.setReportId(creditqueryDetailReportId.equals("-9999") ? "" : creditqueryDetailReportId);
//				PbocCreditqueryDetailVO.setSn(creditqueryDetailSns[i].equals("-9999") ? "" : creditqueryDetailSns[i]);
//				PbocCreditqueryDetailVO
//						.setQueryDate(creditqueryDetailQueryDates[i].equals("-9999") ? "" : creditqueryDetailQueryDates[i]);
//				PbocCreditqueryDetailVO
//						.setQueryUser(creditqueryDetailQueryUsers[i].equals("-9999") ? "" : creditqueryDetailQueryUsers[i]);
//				PbocCreditqueryDetailVO.setQueryReason(
//						creditqueryDetailQueryReasons[i].equals("-9999") ? "" : creditqueryDetailQueryReasons[i]);
//				pbocCreditqueryDetailService.insertPbocCreditqueryDetail(PbocCreditqueryDetailVO);
//			}
//		} catch (ESBException e) {
//			logger.error("百度申请审批服务接口处理失败!" + e.getMessage());
//			return EsbRespServiceBeanCreator.buildesbRespServiceBean(esbReqServiceBean, //
//					JSON.toJSONString(buildRespPbocAppBean(EsbBizEnums.RetCodeEnum.FAILURE.getVALUE(), e.getMessage())), //
//					EsbSysHeadEnums.RetStEnum.FAILURE.getCode(), //
//					EsbBizEnums.RetCodeEnum.FAILURE.getVALUE(), //
//					e.getMessage());
//		} catch (BizException e) {
//			logger.error("百度申请审批服务接口处理失败!" + e.getMessage());
//			return EsbRespServiceBeanCreator.buildesbRespServiceBean(esbReqServiceBean, //
//					JSON.toJSONString(buildRespPbocAppBean(EsbBizEnums.RetCodeEnum.FAILURE.getVALUE(), e.getMessage())), //
//					EsbSysHeadEnums.RetStEnum.FAILURE.getCode(), //
//					EsbBizEnums.RetCodeEnum.FAILURE.getVALUE(), //
//					e.getMessage());
//		} catch (Exception e) {
//			logger.error("百度申请审批服务接口处理失败!" + e.getMessage());
//			return EsbRespServiceBeanCreator.buildesbRespServiceBean(esbReqServiceBean, //
//					JSON.toJSONString(buildRespPbocAppBean(EsbBizEnums.RetCodeEnum.FAILURE.getVALUE(), e.getMessage())), //
//					EsbSysHeadEnums.RetStEnum.FAILURE.getCode(), //
//					EsbBizEnums.RetCodeEnum.FAILURE.getVALUE(), //
//					e.getMessage());
//		} finally {
//			logger.info("百度进件申请交易结束----------报告编号：" + reportId + "------------全局流水号" + glblSrlNo);
//			TraceUtil.clear();
//		}
//		return null;
//	}
//
//	/**
//	 * 征信的返回对象
//	 * 
//	 * @param retStCd
//	 *            返回状态码
//	 * @param rtnMsg
//	 *            返回信息
//	 * @return
//	 * @author weijj
//	 * @since 2019年3月11日 下午19:29
//	 * @version 1.0
//	 */
//	private RespPbocAppBean buildRespPbocAppBean(String retStCd, String rtnMsg) {
//		RespPbocAppBean respPbocAppBean = new RespPbocAppBean();
//		respPbocAppBean.setRetStCd(retStCd);
//		respPbocAppBean.setRtnMsg(rtnMsg);
//		return respPbocAppBean;
//	}
//
//	@Autowired
//	private PatternedLimitableSeqService sequenceService;
//
//	@Autowired
//	@Qualifier("queryReportService")
//	private QueryReportService queryReportService;
//	@Autowired
//	@Qualifier("pbocIdentityService")
//	private PbocIdentityService pbocIdentityService;
//	@Autowired
//	@Qualifier("pbocResidenceService")
//	private PbocResidenceService pbocResidenceService;
//	@Autowired
//	@Qualifier("pbocJobService")
//	private PbocJobService pbocJobService;
//	@Autowired
//	@Qualifier("pbocCreditPromptService")
//	private PbocCreditPromptService pbocCreditPromptService;
//	@Autowired
//	@Qualifier("pbocBadDebtsService")
//	private PbocBadDebtsService pbocBadDebtsService;
//	@Autowired
//	@Qualifier("pbocDeliverySumService")
//	private PbocDeliverySumService pbocDeliverySumService;
//	@Autowired
//	@Qualifier("pbocNoneSettleService")
//	private PbocNoneSettleService pbocNoneSettleService;
//	@Autowired
//	@Qualifier("pbocNoneworkoffCreditcardService")
//	private PbocNoneworkoffCreditcardService pbocNoneworkoffCreditcardService;
//	@Autowired
//	@Qualifier("pbocNoneworkoffNearcreditcardService")
//	private PbocNoneworkoffNearcreditcardService pbocNoneworkoffNearcreditcardService;
//	@Autowired
//	@Qualifier("pbocBondsmanService")
//	private PbocBondsmanService pbocBondsmanService;
//	@Autowired
//	@Qualifier("pbocAssetDetailService")
//	private PbocAssetDetailService pbocAssetDetailService;
//	@Autowired
//	@Qualifier("pbocSponsorialDetailService")
//	private PbocSponsorialDetailService pbocSponsorialDetailService;
//	@Autowired
//	@Qualifier("pbocLoadBasicService")
//	private PbocLoadBasicService pbocLoadBasicService;
//	@Autowired
//	@Qualifier("pbocLoadStatusService")
//	private PbocLoadStatusService pbocLoadStatusService;
//	@Autowired
//	@Qualifier("pbocLoadOverdueService")
//	private PbocLoadOverdueService pbocLoadOverdueService;
//	@Autowired
//	@Qualifier("pbocCreditBasicService")
//	private PbocCreditBasicService pbocCreditBasicService;
//	@Autowired
//	@Qualifier("pbocCreditStatusService")
//	private PbocCreditStatusService pbocCreditStatusService;
//	@Autowired
//	@Qualifier("pbocNearcreditStatusService")
//	private PbocNearcreditStatusService pbocNearcreditStatusService;
//	@Autowired
//	@Qualifier("pbocLoadGuaranteelDetailService")
//	private PbocLoadGuaranteelDetailService pbocLoadGuaranteelDetailService;
//	@Autowired
//	@Qualifier("pbocCreditGuaranteelDetailService")
//	private PbocCreditGuaranteelDetailService pbocCreditGuaranteelDetailService;
//	@Autowired
//	@Qualifier("pbocOwingTaxesService")
//	private PbocOwingTaxesService pbocOwingTaxesService;
//	@Autowired
//	@Qualifier("pbocCivilJudgementService")
//	private PbocCivilJudgementService pbocCivilJudgementService;
//	@Autowired
//	@Qualifier("pbocForcecarryService")
//	private PbocForcecarryService pbocForcecarryService;
//	@Autowired
//	@Qualifier("pbocPunishService")
//	private PbocPunishService pbocPunishService;
//	@Autowired
//	@Qualifier("pbocHouseprovidentService")
//	private PbocHouseprovidentService pbocHouseprovidentService;
//	@Autowired
//	@Qualifier("pbocEndowmentInsurancecacheService")
//	private PbocEndowmentInsurancecacheService pbocEndowmentInsurancecacheService;
//	@Autowired
//	@Qualifier("pbocLowIncomeService")
//	private PbocLowIncomeService pbocLowIncomeService;
//	@Autowired
//	@Qualifier("pbocPracticReqService")
//	private PbocPracticReqService pbocPracticReqService;
//	@Autowired
//	@Qualifier("pbocRewardService")
//	private PbocRewardService pbocRewardService;
//	@Autowired
//	@Qualifier("pbocCarService")
//	private PbocCarService pbocCarService;
//	@Autowired
//	@Qualifier("pbocTelecomService")
//	private PbocTelecomService pbocTelecomService;
//	@Autowired
//	@Qualifier("pbocDescriptionService")
//	private PbocDescriptionService pbocDescriptionService;
//	@Autowired
//	@Qualifier("pbocCreditquerySummaryService")
//	private PbocCreditquerySummaryService pbocCreditquerySummaryService;
//	@Autowired
//	@Qualifier("pbocCreditqueryDetailService")
//	private PbocCreditqueryDetailService pbocCreditqueryDetailService;
//}
